Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Externalising a sheet to reduce Workbook size
I currently have a spreadsheet template of 700KB. This is too large as it is
used to produce some 1-200 sheets a week. Is there any easy way of externalising one of the sheets in the workbook to reduce the template size. The sheet I want to externalise is about 300K on it's own. Because of the size of the sheet, a manual externalisation would take days to accomplish! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Externalising a sheet to reduce Workbook size
Hi
Try Right click on sheet tabMove or Copydo not check Create CopyMove selected sheets to Book(new book)OK -- Regards Roger Govier "Mike Langensiepen" wrote in message ... I currently have a spreadsheet template of 700KB. This is too large as it is used to produce some 1-200 sheets a week. Is there any easy way of externalising one of the sheets in the workbook to reduce the template size. The sheet I want to externalise is about 300K on it's own. Because of the size of the sheet, a manual externalisation would take days to accomplish! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Externalising a sheet to reduce Workbook size
Does this work with templates though?
I used this method to reduce the spreadsheet size after bloating Thanks for the suggestion. "Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message ... Hi Try Right click on sheet tabMove or Copydo not check Create CopyMove selected sheets to Book(new book)OK -- Regards Roger Govier "Mike Langensiepen" wrote in message ... I currently have a spreadsheet template of 700KB. This is too large as it is used to produce some 1-200 sheets a week. Is there any easy way of externalising one of the sheets in the workbook to reduce the template size. The sheet I want to externalise is about 300K on it's own. Because of the size of the sheet, a manual externalisation would take days to accomplish! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Deleting Pictures to reduce workbook size | Excel Discussion (Misc queries) | |||
reduce file size | Excel Discussion (Misc queries) | |||
Need to Reduce the file size | Excel Discussion (Misc queries) | |||
Any tips to reduce excel workbook size? | Excel Discussion (Misc queries) |