Warning when saving in Excel 03 running on XP
 

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.

Warning when saving in Excel 03 running on XP
 

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.

Warning when saving in Excel 03 running on XP
 

It is at "Microsoft Office Excel Workbook" for the sheet i am working in.
However, i have around 15 sheets, do I have to check every sheet in the
workbook?

"Tom Ogilvy" wrote:

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.

Warning when saving in Excel 03 running on XP
 

No. That should be an application level setting.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

It is at "Microsoft Office Excel Workbook" for the sheet i am working in.
However, i have around 15 sheets, do I have to check every sheet in the
workbook?

"Tom Ogilvy" wrote:

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.

Warning when saving in Excel 03 running on XP
 

the warning is still showing, any other ideas?

"Tom Ogilvy" wrote:

No. That should be an application level setting.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

It is at "Microsoft Office Excel Workbook" for the sheet i am working in.
However, i have around 15 sheets, do I have to check every sheet in the
workbook?

"Tom Ogilvy" wrote:

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.

Warning when saving in Excel 03 running on XP
 

I wouldn't have held back if I did have any. Sorry.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

the warning is still showing, any other ideas?

"Tom Ogilvy" wrote:

No. That should be an application level setting.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

It is at "Microsoft Office Excel Workbook" for the sheet i am working in.
However, i have around 15 sheets, do I have to check every sheet in the
workbook?

"Tom Ogilvy" wrote:

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.

Warning when saving in Excel 03 running on XP
 

i do not know why this worked, but i got rid of the error by right clicking
on the file and making a copy. then i renamed the file and opened it and
saved it and the error never showed up again in either file again. the error
was a huge pain for about a day and a half, but noe it is gone. i guess i
should concider myself lucky (until it happens again)

thanks Josh

"Tom Ogilvy" wrote:

I wouldn't have held back if I did have any. Sorry.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

the warning is still showing, any other ideas?

"Tom Ogilvy" wrote:

No. That should be an application level setting.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

It is at "Microsoft Office Excel Workbook" for the sheet i am working in.
However, i have around 15 sheets, do I have to check every sheet in the
workbook?

"Tom Ogilvy" wrote:

Look in Tools=Options in the Transition tab and see what the setting is for
the default format for the "Save Excel Files As:" dropdown.

--
Regards,
Tom Ogilvy


"Josh C" wrote:

I am doing some corrections to an Excel file that my company has created. The
file has a lot of security attached to it, including RMS from MS. When I save
the file, I get an error that reads €œA sheet in the workbook you are trying
to save is password protected. Password protected sheets cannot be saved in a
Web Page. To save this file as a Web Page, you must first remove the
password.€� This warning just started to show up Yesterday. (7/16/2007) The
problem is I do not want the sheets to be saved as a Web Page. I do have
about fifteen password protected sheets that I just what to save as an Excel
file. Does anyone know why it is trying to save the file this way? This
warning comes up every time that I save the file and also when the computer
does an auto save. As of now, I am saving some sheets with passwords and some
sheets without, when I am finished with the file all sheets will be password
protected. I also had a password to open the file, but until I am finished I
have also removed the password for easier access until I am finished. When I
am finished I will be adding a password to open the file.