Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Still problem with larg file size...
I have read the threads on excessive excel file sizes and found the majority
of my sheets go down to 65000, don't ask my why. I have dealt with them all i.e. delete rows method, but for some reason one of my sheets will not delete the unused rows and it still goes IV too 65000, anyone got any ideas. I have tried twice to reduce the size. I do have macro's running, but the macro's only search the sheet, insert a row, paste some data(5 cells) and do an autofit on the columns. Any ideas??? -- Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Still problem with larg file size...
Try also:
Edit Clear Formats -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "DaveyJones" wrote in message ... I have read the threads on excessive excel file sizes and found the majority of my sheets go down to 65000, don't ask my why. I have dealt with them all i.e. delete rows method, but for some reason one of my sheets will not delete the unused rows and it still goes IV too 65000, anyone got any ideas. I have tried twice to reduce the size. I do have macro's running, but the macro's only search the sheet, insert a row, paste some data(5 cells) and do an autofit on the columns. Any ideas??? -- Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Still problem with larg file size...
Yep, thats sorted it, cheers...
-- Dave "Andy Wiggins" wrote: Try also: Edit Clear Formats -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "DaveyJones" wrote in message ... I have read the threads on excessive excel file sizes and found the majority of my sheets go down to 65000, don't ask my why. I have dealt with them all i.e. delete rows method, but for some reason one of my sheets will not delete the unused rows and it still goes IV too 65000, anyone got any ideas. I have tried twice to reduce the size. I do have macro's running, but the macro's only search the sheet, insert a row, paste some data(5 cells) and do an autofit on the columns. Any ideas??? -- Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reducing a size of the shared excel file | Excel Discussion (Misc queries) | |||
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) | |||
Massive large size of Excel File after Updating | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |