Sharing Problems in Excel

5 pts.
Tags:
File Shares
Microsoft Excel
Microsoft Office 2007
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following