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