ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File size (https://www.excelbanter.com/excel-programming/310142-file-size.html)

halem2[_22_]

File size
 
Hi:

I have a simple spreadsheet to make simple calculation, such as a1+c
kinda stuff. I have conditional formatting in about 20 cells and
have about 7 macros running on that sheet plus I'm hidding the menu an
defualt toolbars and have 2 custom toolbars with about 15 icons total.

The file size is 25MB!!!! there's no data just that sheet. IS THER
SOMETHING i'M MISSING HERE? How can I make it smaller?

thank

--
Message posted from http://www.ExcelForum.com


Jean-Yves[_2_]

File size
 
Hi,

Make a google search on reducing file size.
This topic was answered before (not by me).
Other solution.
copy manually to a new workbook your data.

Regards,

JY

"halem2 " wrote in message
...
Hi:

I have a simple spreadsheet to make simple calculation, such as a1+c4
kinda stuff. I have conditional formatting in about 20 cells and I
have about 7 macros running on that sheet plus I'm hidding the menu and
defualt toolbars and have 2 custom toolbars with about 15 icons total.

The file size is 25MB!!!! there's no data just that sheet. IS THERE
SOMETHING i'M MISSING HERE? How can I make it smaller?

thanks


---
Message posted from http://www.ExcelForum.com/




Fable[_7_]

File size
 
Hi,

I had a similar problem, in my case it was formatting of the sheet
customize the entire sheet font, size, conditional formatting you nam
it double the size and triple if you copy the sheet. You may want t
try out from scratch and minimize the formatting too rule that out.

Fabl

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 01:36 AM.

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