L
le_s
Hi
I have a workbook that contains a number of query tables that are based on
named ranges on certain worksheets within the same workbook. The data for
these named ranges come from an external source. The queries refresh properly
after I update the named ranges from the external source, even if I do not
first save the workbook after importing new data. However, after I make this
workbook read-only, although the external data is showing as having been
updated, the queries only pull in the old data (as of the last save, before
it became read-only). Is there any way to leave the workbook as read-only but
still have the queries update based on my new data?
Thanks.
I have a workbook that contains a number of query tables that are based on
named ranges on certain worksheets within the same workbook. The data for
these named ranges come from an external source. The queries refresh properly
after I update the named ranges from the external source, even if I do not
first save the workbook after importing new data. However, after I make this
workbook read-only, although the external data is showing as having been
updated, the queries only pull in the old data (as of the last save, before
it became read-only). Is there any way to leave the workbook as read-only but
still have the queries update based on my new data?
Thanks.