Hi all,

I have a weird problem here.

I have some formulas in a tab looking up data from an external
workbook.

As usual, if the external workbook is open, there is no issue; but with
the source data workbook closed, I get the usual #N/A link

Nothing unusual so far

When I open up the workbook and say 'Dont update' to external links, as
expected, I see the last data that was in the spreadsheet when I
saved/closed it.

I can use the spreadsheet with no issues at all.

On the tab, there is a filter. I can change the filter, play around it
with, no issue

However, I have a custom view with filter settings saved in it.

When I select the custom view - BANG.
All the #N/As are back. For some reason, selecting the custom view
seems to be refreshing the data in my externally linked values

I cannot see the logic in this. Is it a bug?
Much more importantly, can anyone suggest a work-round?

Thanks


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556060