(Msg. 1) Posted: Thu Oct 15, 2009 8:25 am
Post subject: "Save As" Max file size? Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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?
(Msg. 2) Posted: Thu Oct 15, 2009 8:35 am
Post subject: Re: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
On Oct 15, 11:25 am, Sklyn <Sk... RemoveThis @discussions.microsoft.com> wrote:
> 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.
(Msg. 3) Posted: Thu Oct 15, 2009 11:17 am
Post subject: RE: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
"Sklyn" wrote:
> 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.
(Msg. 4) Posted: Sun Oct 18, 2009 5:04 pm
Post subject: RE: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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?
"Sean Timmons" wrote:
> 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.
>
> "Sklyn" wrote:
>
> > 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.
(Msg. 5) Posted: Tue Oct 27, 2009 5:36 pm
Post subject: Re: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
"JP" wrote:
> 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
>
> On Oct 15, 11:25 am, Sklyn <Sk....DeleteThis@discussions.microsoft.com> wrote:
> > 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.
> .
>
(Msg. 6) Posted: Wed Oct 28, 2009 6:26 am
Post subject: Re: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
To use it, you would need to create a function and put it in a
standard module in your VB IDE. For information on where to put the
function, see http://www.rondebruin.nl/code.htm
--JP
On Oct 27, 8:36 pm, Sklyn <Sk....RemoveThis@discussions.microsoft.com> wrote:
> 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
>
>
>
> "JP" wrote:
> > 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
(Msg. 7) Posted: Mon Nov 02, 2009 6:03 pm
Post subject: Re: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks JP,
Appreciate ur time..
"JP" wrote:
> It's a VBA function you can use to make a disk file read-only. You
> would run it after you save the workbook. See
> http://www.techonthenet.com/excel/formulas/setattr.php >
> To use it, you would need to create a function and put it in a
> standard module in your VB IDE. For information on where to put the
> function, see http://www.rondebruin.nl/code.htm >
> --JP
>
> On Oct 27, 8:36 pm, Sklyn <Sk... RemoveThis @discussions.microsoft.com> wrote:
> > 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
> >
> >
> >
> > "JP" wrote:
> > > 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
> .
>
(Msg. 8) Posted: Tue Nov 03, 2009 9:42 am
Post subject: Re: "Save As" Max file size? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Welcome!
--JP
On Nov 2, 9:03 pm, Sklyn <Sk....DeleteThis@discussions.microsoft.com> wrote:
> Thanks JP,
> Appreciate ur time..
>
>
>
> "JP" wrote:
> > It's a VBA function you can use to make a disk file read-only. You
> > would run it after you save the workbook. See
> >http://www.techonthenet.com/excel/formulas/setattr.php
>
> > To use it, you would need to create a function and put it in a
> > standard module in your VB IDE. For information on where to put the
> > function, seehttp://www.rondebruin.nl/code.htm >
> > --JP
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office