Excel Excell .xls File Growing Fast

Joined
Apr 13, 2015
Messages
1
Reaction score
0
Hello,

I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns.

Each day we create a copy of this file, and in the new copy, change the numeric value of 20 cells.

No new columns or rows are added, there are no graphics/charts/etc. There is only one sheet.

10 days ago, the file size was 1.7MB. The next day it grew to 3 MB. The following day 7.

Today the file is 20 MB and working with it is very slow. It takes approximately 10 minutes to open, 10 minutes to save, and clicking anywhere in the file has a 30 second delay.

Sharing is not enabled on this file. I'm not sure what the issue could be, any suggestions. I've tried an "Open & Repair" but no luck. It also doesn't link to an external file, and it doesn't have any VBA code.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top