Editor's Blog3 mins ago
Large file size for excel
Hi
I have an excel file that is over 2meg in size but contains very little information. Even if i delete all the infomation in the file the size does not go down by much. I cannot see any hidden sheets/workbooks or macros. Is there any way i can find out what is actually causing the file to be so big?
I have an excel file that is over 2meg in size but contains very little information. Even if i delete all the infomation in the file the size does not go down by much. I cannot see any hidden sheets/workbooks or macros. Is there any way i can find out what is actually causing the file to be so big?
Answers
Best Answer
No best answer has yet been selected by Birt. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.G'Day
The actual spreadsheet may be bigger than you think. There may be cells, a long way from where you think the boundaries of the spreadsheet are, that have single spaces in them. Just to check, open the spreadsheet and press Ctrl+End and see where you end up. You may end up in some ridiculous location like AD400 or something. Where ever you end up will mean there is a cell in that column on some row with a value in it (space is a value) and a value in a cell in some column in that row.
Make a backup copy then try the following:
Make sure the sheets are Ungrouped - you want to do this one sheet at a time. Try deleting all the rows from the last row +1 that you use to the last row Excel thinks is the last and likewise from the last column+1 (you) to the last column (Excel); do this for each sheet and delete "blank" (unused) sheets and then resave it. See if that reduces the size of the file.
This can happen if the spreadsheet has become smaller over time but people have just typed in spaces in cells that become unused instead of deleting the cells.
Geoff
The actual spreadsheet may be bigger than you think. There may be cells, a long way from where you think the boundaries of the spreadsheet are, that have single spaces in them. Just to check, open the spreadsheet and press Ctrl+End and see where you end up. You may end up in some ridiculous location like AD400 or something. Where ever you end up will mean there is a cell in that column on some row with a value in it (space is a value) and a value in a cell in some column in that row.
Make a backup copy then try the following:
Make sure the sheets are Ungrouped - you want to do this one sheet at a time. Try deleting all the rows from the last row +1 that you use to the last row Excel thinks is the last and likewise from the last column+1 (you) to the last column (Excel); do this for each sheet and delete "blank" (unused) sheets and then resave it. See if that reduces the size of the file.
This can happen if the spreadsheet has become smaller over time but people have just typed in spaces in cells that become unused instead of deleting the cells.
Geoff
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.