Excel File Size Bloats when using Protection?
- From: figlet@xxxxxxxxx
- Date: Tue, 29 Jan 2008 13:45:01 -0800 (PST)
I have an excel file that started off at about 143K.
It is an employee appraisal form, and it needed a redesign, with the
constraint that it stay in excel (argh).
Anyway, each question was moved to a separate tab, so that I have 8
worksheets in my book.
I locked A1-A4 so that the instructions cannot be changed.
I hid all columns from B to IV.
I enabled protection and allowed users to change row format, add a
row, or delete a row, for each page for rows 5 through whatever they
needed.
The first page is fully protected (more instructions).
The file bloated to 12mB. Is this because of adding the protections?
.
- Follow-Ups:
- RE: Excel File Size Bloats when using Protection?
- From: Jim Thomlinson
- RE: Excel File Size Bloats when using Protection?
- Prev by Date: Re: Please Help! Automatically moving decimal points
- Next by Date: Re: lots of data to be sorted for each unique record
- Previous by thread: Re: How do I set up a hyperlink to a word in a paragraph?
- Next by thread: RE: Excel File Size Bloats when using Protection?
- Index(es):