View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victor Victor is offline
external usenet poster
 
Posts: 39
Default Settings for pop up alerts in excel

Our acct department has upgraded to 07. They are still keeping all files in
97-03 format. Most of their financial sheets are password protected or
encrypted. When you have a password or pretected sheet open in Excel 07 but
it is in 97-03 format, a pop up appears every time you try to save. THe
message says that the file is encrypted and or password protected and in an
older version of excel. It then goes on to say that Excel 07 offers better
encryption protection and do you want to convert this file to 07 format? the
choices are Yes or No and the Yes button is selected by default.

This message appears EVERY time you try to save these files. is there any
way to stop this message box from appearing? I have looked all over the
options but it seems that 07 has removed a lot of a users ability to
configure the software to meet their needs.

Any help would be great.