View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Langensiepen Mike Langensiepen is offline
external usenet poster
 
Posts: 18
Default 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!