| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add a warning before running a macro | Excel Discussion (Misc queries) | |||
| Re : Security warning when saving downloaded file from Excel Options | Excel Discussion (Misc queries) | |||
| Security warning when saving downloaded file from Excel | Excel Discussion (Misc queries) | |||
| Warning before saving files! | Excel Discussion (Misc queries) | |||
| excel running slow when saving | Excel Discussion (Misc queries) | |||
Hybrid Mode
