I am not getting "Enable Automatic Refresh" in excel 2007...

[mohanyathish]

Hi,

I was using Excel 2003 until recently. I had created certain worksheets which collected data from the web using web query. When i opened the document in excel 2003, i used to get a prompt window asking for enable or disable automatic refresh.

now, i have switched to excel 2007. i am not get the prompt window asking for enable or disable automatic refresh.

Kindly help.

 

[Trevor G]

Look at the Office Button (Top Left) then select Options from the list, and then look at the settings you have in the Formula side for Workbook Calculations. Or check around the Options to see if you have something switched off/on.