B
baxybaxy
Hi all,
I have a weird problem here.
I have some formulas in a tab looking up data from an externa
workbook.
As usual, if the external workbook is open, there is no issue; but wit
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, a
expected, I see the last data that was in the spreadsheet when
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 i
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 vie
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?
Thank
I have a weird problem here.
I have some formulas in a tab looking up data from an externa
workbook.
As usual, if the external workbook is open, there is no issue; but wit
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, a
expected, I see the last data that was in the spreadsheet when
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 i
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 vie
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?
Thank