Reresh data is not working

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!
 
A

alcorjr

Are you using the command "Refresh" (an exclamation sign) or "Refres
ALL" (exclamation sign on an xcel icon). ?
Are you refresing from the web
 
J

Jim

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.
 

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

Similar Threads

Embed the same Excel multiple times 0
Worksheet Protection and Refresh External Data 0
Protected Sheet and allowing External Data Refresh 2
Syncing between source worksheet and dependent worksheets 0
Cell data entering slow! 0
MS Excel Error: Too many client tasks 2
need help on either doing a loop and counting specific values orusing subtotal function 2
Consolidation Table from Different Excel Tabs with Different Format 1

Top