ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How big is too big for an Excel file? (https://www.excelbanter.com/excel-discussion-misc-queries/120772-how-big-too-big-excel-file.html)

Penny C.

How big is too big for an Excel file?
 
I've got an Excel file that is nearly 9MB. It has 68 tabs, half of which are
mostly formulas. Management uses it as the be-all-end-all data repository
for our KPMs, and they refuse to allow me to paste values in for some of the
older data (it goes back to 1998). I caution them each time we add a new tab
that I'm nervous about how much more it will take and that formulas could get
corrupt, etc. I've done everything I can think of to make sure it is as
small as possible without deleting anything or changing formulas. Because of
some of the calculations, it is not easily put into an Access database. Am I
worried for nothing? It has been taking longer and longer to open and save
it.


All times are GMT +1. The time now is 03:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com