Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIG FILE SIZE??
I have a sheet that was sent to me and ends up being 33 meg. It doesn't have
very many formulas so I can't figure why it's so large. This guy did copy info from another worksheet and paste in, but can't see any embedded images or other things that might make so large. How do I search for the culprit? Thanks much. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIG FILE SIZE??
Hello! These may be too simple, but try...
Go into each tab and hit CTRL+END. This will show you where the spreadsheet ends (there may be blank rows/cells but Excel thinks there is something in them). To get rid of the blank cells, figure out which is the "real" last row/column of data. Highlight and Delete all empty rows/columns then hit CTRL+HOME and save the file right away. This should re-train Excel to see the real end of the data. Also, try going to format-sheet-unhide to see if there are any hidden tabs that you can unhide and delete. Hope this helps! Good Luck! Megan "RR WILL" wrote: I have a sheet that was sent to me and ends up being 33 meg. It doesn't have very many formulas so I can't figure why it's so large. This guy did copy info from another worksheet and paste in, but can't see any embedded images or other things that might make so large. How do I search for the culprit? Thanks much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reducing file size | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
excel file size bloat | Excel Discussion (Misc queries) |