Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
One of my coworkers asked me to shrink a file size of Large excel file. It has only one worksheet and also few contents but it sizes over 11MB !! When I scrolled it down, I feel a delay but there's nothing special to consume a resource on it. I looked for other options objects, any unkown link, voices which can make it large, but there's nothing of them. I tried to remove all contents first. Secondly, when I tried to remove a border (table) on it, I met an Excel hang. Those borders donot seem to move/copy other workseet. I wasnot able to remove borders so I copied all then pasted them on new Excel sheet without border. Then new Excel sheet turns normal size now. I have no idea why this border info make this Excel file so big. Would somebody let me know how to fix it not like this ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel file size increases when editing same info | Excel Discussion (Misc queries) | |||
How do I make the border of an active cell in Excel darker? | Excel Discussion (Misc queries) | |||
too much info in one cell in excel how do I make it 2 lines? | Excel Discussion (Misc queries) | |||
Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
Excel Sheet - Hidden Border or Frame | Excel Discussion (Misc queries) |