Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL FILE SIZE
I have a multi-worksheet spreadsheet that guys at work added company logo's
too (jpg) file, as they thought it was a cool idea to put logos on custom labels for product- and each file got over 10 megabytes in size, where the original file was only like 0.5MB . . We removed the images and viola-- file did not reduce in size. Does anyone have any hints for shrinking the file back down in size more like its original dimensions? Thanks Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL FILE SIZE
Chances are the jpg images are not your problem. More likely you have stored
cell in memory that are not being used. Look at the scroll bars on each of the sheets. Can you scroll well past the end of the data. If so then you have cells that need to be deleted. Check out this link for instructions... http://www.contextures.com/xlfaqApp.html#Unused Why do my scrollbars go to row 500 -- my data ends in cell E50? -- HTH... Jim Thomlinson "Anon" wrote: I have a multi-worksheet spreadsheet that guys at work added company logo's too (jpg) file, as they thought it was a cool idea to put logos on custom labels for product- and each file got over 10 megabytes in size, where the original file was only like 0.5MB . . We removed the images and viola-- file did not reduce in size. Does anyone have any hints for shrinking the file back down in size more like its original dimensions? Thanks Paul |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL FILE SIZE
Thanks- I will try it out this AM. The labels are full of merged cells, so
I will have to check the ranges of the 7 or 8 worksheets manually. Thanks again. Paul "Jim Thomlinson" wrote in message ... Chances are the jpg images are not your problem. More likely you have stored cell in memory that are not being used. Look at the scroll bars on each of the sheets. Can you scroll well past the end of the data. If so then you have cells that need to be deleted. Check out this link for instructions... http://www.contextures.com/xlfaqApp.html#Unused Why do my scrollbars go to row 500 -- my data ends in cell E50? -- HTH... Jim Thomlinson "Anon" wrote: I have a multi-worksheet spreadsheet that guys at work added company logo's too (jpg) file, as they thought it was a cool idea to put logos on custom labels for product- and each file got over 10 megabytes in size, where the original file was only like 0.5MB . . We removed the images and viola-- file did not reduce in size. Does anyone have any hints for shrinking the file back down in size more like its original dimensions? Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Excel 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) | |||
Excel file size too big | Excel Discussion (Misc queries) |