Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
large excel file
hi,
i'm working with 7900 kb excel file. i know there is a limit of the file size. is there any option to "clean" the file? it had a lot of details but it probably include some junk links, names, formats of deleted lines... is there any clean tool? thanks in advance... -- Miri Tz. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
large excel file
8Mb is a large file but not nearing the capacity of Excel. The limits are
65,536 rows, 256 columns, the amount of hard disk space and, to some extent, the speed of the processor. If you're concerned about the speed of operation this depends not only on the size of the files but the amount of formulae. I have a large file which opens quite quickly and a much smaller file which is crammed with formulae to be ralculated when opened which takes much longer. Cleaning a spreadsheet file is a very personal thing depending on what information is included and what YOU can justify to yourself as not wanted - but remember once it's gone, it's gone. Once you've deleted unwanted columns I would suggest you sort rows so that you can bring together any you don't want (e.g. everyone living in a particular town) and delete the rows together. You could, then delete all columns to the right of the last known column and all rows below the last known row to make sure that nothing is lurking in what is supposed to be an empty area. Regards. Bill Ridgeway Computer Solutions "Miri" wrote in message ... hi, i'm working with 7900 kb excel file. i know there is a limit of the file size. is there any option to "clean" the file? it had a lot of details but it probably include some junk links, names, formats of deleted lines... is there any clean tool? thanks in advance... -- Miri Tz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large excel file | Excel Discussion (Misc queries) | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Massive large size of Excel File after Updating | Excel Discussion (Misc queries) | |||
Excel file very large in size? | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) |