| 1. |
Solve : Need Help Finding PC that Can Run Two Displays? |
|
Answer» I want to buy a new PC computer primarily used for spreadsheets, internet surfing and e-mail. My current computer is about 5 years old and only has 512MB ram. I have some large excel spreadsheets (100MB, 65000 rows) that take over a minute to open or save which is way to slow for me. I was thinking of buying the GATEWAY DX4831-01E (6GB memory, Intel i3-530 processor, 1TB HD) for $550 at Best Buy. Will this computer be able to open/save my spreadsheets in a few seconds? Is there a better computer in this price range for my needs? Will this computer be able to open/save my spreadsheets in a few seconds?Surely, it will open your spreadsheets much faster, probably in a few seconds. By the way, I'm thinking a database might be better than Excel for your application. If your spreadsheet is being used to maintain a large amount of data that could be converted to database, a database such as Microsoft Access will be less memory-intensive than a spreadsheet. Quote from: soybean on March 09, 2010, 09:48:19 AM By the way, I'm thinking a database might be better than Excel for your application. If your spreadsheet is being used to maintain a large amount of data that could be converted to database, a database such as Microsoft Access will be less memory-intensive than a spreadsheet. I was goign to say something along these lines as well- basically, when you have an excel spreadsheet that takes up more then a few pages worth of rows your no longer using Excel as it was designed, but rather as a database program to maintain a list of data. The difference between Excel and Access is that Access (and really, any database application) can be used to quickly lookup data based on various fields and MODIFY data and so forth- Excel provides- sorting, and standard search features. The core ISSUE is is simply that Excel is not a scalable solution for your data; a database, however, is. There are tools that can be used to create a Jet (access) database from an Excel spreadsheet, too. |
|