Query Problem with Read-Only Workbook

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top