| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel kept on asking to save file every time I jump from one sheet to another!
Hi,
I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
Are you sure you don't get this message even if it isn't sharepoint?
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- wrote in message oups.com... Hi, I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
Hi Ken,
The message never occur on my computer with or without accessing sharepoint. But however, my coworkers sometimes get that message. we are sharing the file accross the regions and all of the people from different regions recieved the message asking to save the file every time they jump from one sheet to another. Thanks, Tim Ken Wright wrote: Are you sure you don't get this message even if it isn't sharepoint? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- wrote in message oups.com... Hi, I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
Are any of the macros event macros?
It seems weird that it doesn't happen to you, yet it happens to others. Regards Ken.................. wrote in message oups.com... Hi Ken, The message never occur on my computer with or without accessing sharepoint. But however, my coworkers sometimes get that message. we are sharing the file accross the regions and all of the people from different regions recieved the message asking to save the file every time they jump from one sheet to another. Thanks, Tim Ken Wright wrote: Are you sure you don't get this message even if it isn't sharepoint? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- wrote in message oups.com... Hi, I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
Hi Ken,
Yes, I have used the "worksheet_Activate" event for the macros. Thanks, Tim Ken Wright wrote: Are any of the macros event macros? It seems weird that it doesn't happen to you, yet it happens to others. Regards Ken.................. wrote in message oups.com... Hi Ken, The message never occur on my computer with or without accessing sharepoint. But however, my coworkers sometimes get that message. we are sharing the file accross the regions and all of the people from different regions recieved the message asking to save the file every time they jump from one sheet to another. Thanks, Tim Ken Wright wrote: Are you sure you don't get this message even if it isn't sharepoint? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- wrote in message oups.com... Hi, I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
OK, so if you have your macro do anything within the file you are likely to
get that message when you try to close it. What does your macro do? Regards Ken................ wrote in message oups.com... Hi Ken, Yes, I have used the "worksheet_Activate" event for the macros. Thanks, Tim Ken Wright wrote: Are any of the macros event macros? It seems weird that it doesn't happen to you, yet it happens to others. Regards Ken.................. wrote in message oups.com... Hi Ken, The message never occur on my computer with or without accessing sharepoint. But however, my coworkers sometimes get that message. we are sharing the file accross the regions and all of the people from different regions recieved the message asking to save the file every time they jump from one sheet to another. Thanks, Tim Ken Wright wrote: Are you sure you don't get this message even if it isn't sharepoint? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- wrote in message oups.com... Hi, I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
Hi Ken,
I used the macros to send emails and update the values whenever the sheet is activated. The macro that i used for sending emails is based on the click buttons (command buttons). Thanks, Tim Ken Wright wrote: OK, so if you have your macro do anything within the file you are likely to get that message when you try to close it. What does your macro do? Regards Ken................ wrote in message oups.com... Hi Ken, Yes, I have used the "worksheet_Activate" event for the macros. Thanks, Tim Ken Wright wrote: Are any of the macros event macros? It seems weird that it doesn't happen to you, yet it happens to others. Regards Ken.................. wrote in message oups.com... Hi Ken, The message never occur on my computer with or without accessing sharepoint. But however, my coworkers sometimes get that message. we are sharing the file accross the regions and all of the people from different regions recieved the message asking to save the file every time they jump from one sheet to another. Thanks, Tim Ken Wright wrote: Are you sure you don't get this message even if it isn't sharepoint? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- wrote in message oups.com... Hi, I am working on this Excel file that has hyperlinks and some small macro. I used hyperlinks to jump from one sheet to another, and the file didn't have any volatile function. We post the file onto the sharepoint and set the sharepoint permission to "Read Only". when we open the file directly from the sharepoint and try to navigate around, the file kept on asking us to save changes every time we click on the hyperlinks; even though we didn't make any changes. I couldn't figure out whether there is a problem with Sharepoint or with the Excel File itself. Please let me know if you have any idea. I hope I asked this in the right group, if not, please point me in the right direction. Thanks, Tim |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
It doesn't have any code that closes the file at all?
Regards Ken.............. wrote in message ups.com... Hi Ken, I used the macros to send emails and update the values whenever the sheet is activated. The macro that i used for sending emails is based on the click buttons (command buttons). Thanks, Tim <snip |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel kept on asking to save file every time I jump from one sheet to another!
Hi Ken,
No, I don't have any code to close the file. I have around 60 sheets total in the workbook. I have written the worksheet protection function that protects all the sheets at once. I wonder if that would cause the problem. Here is the code that i used to protect all the sheets: Sub Protect_Sheets() Dim wSheet As Worksheet Sheet15.Select 'Activate this sheet to update the values Sheet22.Select 'Activate this sheet to update the values Sheet47.Select 'Activate this sheet to update the values Sheet50.Select 'Activate this sheet to update the values Sheet51.Select 'Activate this sheet to update the values Sheet52.Select 'Activate this sheet to update the values If txtPW < "XXXX" Then MsgBox ("INCORRECT PASSWORD! PLEASE ENTER PASSWORD AGAIN:") txtPW = "" Exit Sub End If For Each wSheet In Worksheets If wSheet.ProtectContents = False Then wSheet.Protect Password:=txtPW End If Next wSheet txtPW = "" cmd_OK.Caption = "UnProtect" cmd_ProtectData.Caption = "UnProtect Data Sheet" ' Unload Me End Sub Ken Wright wrote: It doesn't have any code that closes the file at all? Regards Ken.............. wrote in message ups.com... Hi Ken, I used the macros to send emails and update the values whenever the sheet is activated. The macro that i used for sending emails is based on the click buttons (command buttons). Thanks, Tim <snip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel files takes a huge amount of time | Excel Discussion (Misc queries) | |||
| Time Required to Save a File | Excel Discussion (Misc queries) | |||
| Save file in excel | Setting up and Configuration of Excel | |||
| how to let excel ask to save the sheet when closing the excel file | Setting up and Configuration of Excel | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
