Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Bloats when using Protection?
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection on excel file | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
Remove file Protection from an Excel workbook file from others | Excel Discussion (Misc queries) | |||
Excel file protection? | Excel Discussion (Misc queries) | |||
Excel file protection again? | Excel Discussion (Misc queries) |