Refresh external data message

[Jimbola]

Hi

I have a workbook that comprises of 2 worksheet, wk1 and
wk2. Wk1 has detail information which feeds into a pivot
table in wk2. I have one macro attached to the activate
event on wk2 to refresh the pivot table.

However, every time I open the workbook I get a message
saying "This workbook contains queries to external data
that refresh automatically......" "Enable automatic
refresh" or "Disable automatic refresh".

To the best of my knowledge I don't have any queries or
links...can anyone tell me why this message is coming up
and how to get rid of it..I have tried both the options
but to no avail.


Jim

 

[Frank Kabel]

Hi
use the following addin to find/delete these links (maybe stored in a
defined name)
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip