Excel kept on asking to save file every time I jump from one sheet to another!

[[email protected]]

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

[Ken Wright]

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 :-)
------------------------------*------------------------------*----------------

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[[email protected]]

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
>
> ------------------------------=AD------------------------------=AD-------=
---------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------=AD------------------------------=AD-------=
---------
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

[Ken Wright]

Are any of the macros event macros?

It seems weird that it doesn't happen to you, yet it happens to others.

Regards
Ken..................

<[email protected]> wrote in message
news:[email protected]...
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 :-)
> ------------------------------*------------------------------*----------------
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

[[email protected]]

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..................
>
> <[email protected]> wrote in message
> news:[email protected]...
> 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
> >
> > ------------------------------=AD------------------------------=AD-----=
-----------
> > It's easier to beg forgiveness than ask permission :-)
> > ------------------------------=AD------------------------------=AD-----=
-----------
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >

[Ken Wright]

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................


<[email protected]> wrote in message
news:[email protected]...
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..................
>
> <[email protected]> wrote in message
> news:[email protected]...
> 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 :-)
> > ------------------------------*------------------------------*----------------
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >

[[email protected]]

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................
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> 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..................
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > 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
> > >
> > > ------------------------------=AD------------------------------=AD---=
-------------
> > > It's easier to beg forgiveness than ask permission :-)
> > > ------------------------------=AD------------------------------=AD---=
-------------
> > >
> > > <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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 arou=
nd,
> > > > the file kept on asking us to save changes every time we click on t=
he
> > > > hyperlinks; even though we didn't make any changes. I couldn't figu=
re
> > > > out whether there is a problem with Sharepoint or with the Excel Fi=
le
> > > > 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
> > > >

[Ken Wright]

It doesn't have any code that closes the file at all?

Regards
Ken..............


<[email protected]> wrote in message
news:[email protected]...
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>

[[email protected]]

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..............
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> 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>