Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File size
I have followed the instructions in the forum concerning reducing an excel
file size. The workbook contains six worksheets with pivot tables, macros and custom functions. The file size is approx 870KB. After hiding rows and columns that I dont want other people to see the file size became approx 8.1MB. I unhid the rows and columns and the size is back to 870KB. Is this normal? I guess my other option is to have white text on a white background but that seems a bit primitive when the hide feature is there. Thanks Peter |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File size
I have had issues like this in the past and have always solved them, but have
never come across this type of query, where size changes in this way. If you wish, you can email me your spreadsheet, and i will take a look. Thanks Matt Peter D wrote: I have followed the instructions in the forum concerning reducing an excel file size. The workbook contains six worksheets with pivot tables, macros and custom functions. The file size is approx 870KB. After hiding rows and columns that I dont want other people to see the file size became approx 8.1MB. I unhid the rows and columns and the size is back to 870KB. Is this normal? I guess my other option is to have white text on a white background but that seems a bit primitive when the hide feature is there. Thanks Peter -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200809/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce 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) | |||
WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) |