We are running excel 2007. We have a workbook that is approaching 12 mb in size, and takes a very long time to open and save. We are running Gigabit adapters in the server and the workstation. Opening and saving using excel 2003 took seconds. Under XL 2007 it takes what seems like forever.
The workbook has 20 some odd sheets, and each sheet has custom column & row widths as well as custom formatting.
My idea is to copy and paste all of these sheets into one large sheet. Then delete all the other sheets. Then I would like to select a range that contains the information for what we want to do from this one larger sheet, and paste the range into a temporary sheet.
The problem is formatting the sheet so that column and row sizes are appropriate.
Is there any (relatively quick) way to save the column and row widths, formatting and fonts from the original sheets to format the temporary sheet?
Any other ideas for reducing the file size would be greatly appreciated.