"Save As" Max file size?

  • Thread starter Thread starter Sklyn
  • Start date Start date
S

Sklyn

Hi guys, This is gunna seem like a really dumb question,,,

But, In Excel 2003 is there a max file size which you can use "save as".
I have a workbook which I wish to make read only but the save as function
always causes excel to "Not Responding".
On smaller workbooks it works fine.
Is it just my workstation can't cope with it or could there be some other
issue?
I can copy the closed file and rename no problem.
Is there another way to create a 'Read Only' file?

Thanks for your understanding and assistance.
 
You can do it programmatically.

SaveAs has a ReadOnlyRecommended property which you can set to True.
This is the feature that, when you open a workbook, asks if you want
to open the file as read only.

Or, if you want the file to be read-only from a disk-writing
perspective, the SetAttr function can do this.

SetAttr workbookname, vbReadOnly

Where "workbookname" is the path and filename of the workbook you just
saved and want to write-protect.

--JP
 
Sounds like your file may have lots of formulas and such?

You CAN save as, then hit the Esc key. It will ask if you want to
recaluclate before saving, and you can say no.

Then, you can do whatever you need...

Another option is to put a pasword on the file (Tools > Options > Security).

anyone who attempts to open the file will be asked for the password with the
option of selecting Read Only instead.

*Please note, Excel security is limited. If someone REALLY wants to break
the security, they can.
 
Yeah there are a lot of formulas and links to other sheets etc.
Esc is not working for me..
Its fine when I open save as and set my options, but after I hit save
nothing else responds?
 
Thanks for your help,

What is the SetAttr Function? and how do I use it?
I am more curious about Save As not working though..

Cheers
 
Back
Top