Excel spreadsheet will not update

C

Cameron

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?
 
X

xlm

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,
 
C

Cameron

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

xlm

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top