View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cameron Cameron is offline
external usenet poster
 
Posts: 42
Default 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?