Excel spreadsheet will not update
 

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?

Excel spreadsheet will not update
 

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?

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?

Excel spreadsheet will not update
 

maybe redo the query and save the query would help.
other than this, I may need to see the workbook.

Apology, afraid this isn't much help.....
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Cameron" wrote:

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?