Reresh data is not working

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hi all,

When I do a Refesh Data in one worksheet, it updates
(tries to refresh) the data in another worksheet. The
problem is that it is not working correctly. How was this
set up? Another words, how is it that this other
worksheet is being updated when I refesh the data in only
one. I am hoping that by knowing the answer to this
question, I can troubleshoot the problem.

Thanks in advance for the help!
 
Are you using the command "Refresh" (an exclamation sign) or "Refres
ALL" (exclamation sign on an xcel icon). ?
Are you refresing from the web
 
I believe Refresh Data works on the active sheet, not all linked files. In
other words, if you select Refresh Data on Worksheet A, it refreshes the
data linked to that Worksheet from Worksheets B and C. It does not refresh
the data from Worksheets D and E that ARE NOT linked to Worksheet A.
 
Back
Top