Externalising a sheet to reduce Workbook size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Langensiepen - 09 Nov 2007 03:18 GMT

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 to this Message

Roger Govier - 09 Nov 2007 12:56 GMT

Hi

Try
Right click on sheet tab>Move or Copy>do not check Create Copy>Move selected
sheets to Book>(new book)>OK

Signature

Regards
Roger Govier

>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
[quoted text clipped - 3 lines]
> Because of the size of the sheet, a manual externalisation would take days
> to accomplish!

Reply to this Message

Mike Langensiepen - 14 Nov 2007 01:51 GMT

Does this work with templates though?

I used this method to reduce the spreadsheet size after bloating

Thanks for the suggestion.

> Hi
>
[quoted text clipped - 8 lines]
>> Because of the size of the sheet, a manual externalisation would take
>> days to accomplish!

Reply to this Message