Excel spreadsheet will not update
I passed the information on to the user and they are on Automatic for
calculations. But still excel will not show the new information.
What happens is new data is queried, and then a table is built with that
data. A form is opened that calls excel with a custom spreadsheet that has
been linked to the data. When this person opens that form she doesn't see the
updated data in excel, but others have no problems.
So I am a bit stumped.
"xlm" wrote:
would it be that her Calculation mode is set to manual?
Go to Tool Option Calculation
change it to Automatic
Or she can try press the F9 key on the keyboard
HTH
--
If this posting was helpful, please click on the Yes button
Thank You
cheers,
"Cameron" wrote:
I have a user that when opening an excel spreadsheet that is linked to a
database doesn't see the records update even if she pressed the refresh
records icon.
And yet other users do not have this problem. What might be the issue with
her version of excel?
|