| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File size increased 7-fold!
My file size was about 480kb. I then added a couple of additional macros
(maybe about 5 more, relatively short), and added some conditional formatting. Suddenly the file size jumped to an unwieldy 3.8mb! Half a meg was kind of large, 3.8mb is almost unusable. Any suggestions? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File size increased 7-fold!
Probably needs the used ranges on each sheet reset
See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 3 Jul 2006 16:37:01 -0700, bman342 wrote: My file size was about 480kb. I then added a couple of additional macros (maybe about 5 more, relatively short), and added some conditional formatting. Suddenly the file size jumped to an unwieldy 3.8mb! Half a meg was kind of large, 3.8mb is almost unusable. Any suggestions? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File size increased 7-fold!
Interesting, thanks. I have four different worksheets in this WB. Sure enough
one of the worksheets had the scroll setting all the way to the bottom row. After trying some of her manual resets, I just copied the file under a different filename and deleted the suspected culprit WS, and that worked. Luckily it's a fairly simple sheet to redo. "Gord Dibben" wrote: Probably needs the used ranges on each sheet reset See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 3 Jul 2006 16:37:01 -0700, bman342 wrote: My file size was about 480kb. I then added a couple of additional macros (maybe about 5 more, relatively short), and added some conditional formatting. Suddenly the file size jumped to an unwieldy 3.8mb! Half a meg was kind of large, 3.8mb is almost unusable. Any suggestions? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File size increased 7-fold!
Happy to hear you're sorted.
Now.........to find out why the increase in size<g Gord On Mon, 3 Jul 2006 19:43:01 -0700, bman342 wrote: Interesting, thanks. I have four different worksheets in this WB. Sure enough one of the worksheets had the scroll setting all the way to the bottom row. After trying some of her manual resets, I just copied the file under a different filename and deleted the suspected culprit WS, and that worked. Luckily it's a fairly simple sheet to redo. "Gord Dibben" wrote: Probably needs the used ranges on each sheet reset See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 3 Jul 2006 16:37:01 -0700, bman342 wrote: My file size was about 480kb. I then added a couple of additional macros (maybe about 5 more, relatively short), and added some conditional formatting. Suddenly the file size jumped to an unwieldy 3.8mb! Half a meg was kind of large, 3.8mb is almost unusable. Any suggestions? Thanks. |
| 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) | |||
Linear Mode
