Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File size xls
Dear all,
Is it usual for excel files to be quite large. I have files with about 8 worksheets. Each worksheet contains data pertaining to 100 students. One sheet has graphs and there is much linking, vlookuping and calculations going on in each sheet and amongst sheets. I have also used quite a lot of colouring for effect. Would this result in a 2MB file? regards Molly |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File size xls
Would this result in a 2MB file?
Probably. In the grand scheme of things, 2MB isn't all that big. Check you used range: (do this on each sheet) http://contextures.com/xlfaqApp.html#Unused And check here for ideas on optimization: http://www.decisionmodels.com/ Biff "Molly" wrote in message ... Dear all, Is it usual for excel files to be quite large. I have files with about 8 worksheets. Each worksheet contains data pertaining to 100 students. One sheet has graphs and there is much linking, vlookuping and calculations going on in each sheet and amongst sheets. I have also used quite a lot of colouring for effect. Would this result in a 2MB file? regards Molly |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File size xls
Thank you for your response. I feel better now that some gremlin is not
generating big files. regards Molly "Biff" wrote: Would this result in a 2MB file? Probably. In the grand scheme of things, 2MB isn't all that big. Check you used range: (do this on each sheet) http://contextures.com/xlfaqApp.html#Unused And check here for ideas on optimization: http://www.decisionmodels.com/ Biff "Molly" wrote in message ... Dear all, Is it usual for excel files to be quite large. I have files with about 8 worksheets. Each worksheet contains data pertaining to 100 students. One sheet has graphs and there is much linking, vlookuping and calculations going on in each sheet and amongst sheets. I have also used quite a lot of colouring for effect. Would this result in a 2MB file? regards Molly |
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) |