Sharing Problems in Excel
5 pts.
0
Q:
Sharing Problems in Excel
We have several spreadsheets that we share with 5 users. Some of these worksheets seem to grow to a large size in a short amount of time, even though they actually don't contain that much information. These are files that several people are updating and viewing many times per day. For example, I had a file which said it was about 96,000 kb and when I copied the date and pasted it into a new spreadsheet, the file was only about 250 kb in size. When these files get so large, it makes it difficult and slow to open, edit and save.

Software/Hardware used:
Excel 2003, Office 2003
ASKED: Aug 25 2009  4:50 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
23535 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Instead of spreadsheets, you should start looking into a database application to improve performance. It also helps with file locking and file corruption when users access the data at the same time.
Last Answered: Aug 25 2009  10:03 PM GMT by Mshen   23535 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0