Query starts a "read only" copy of the source sheet

  • Thread starter Thread starter GorKoUSA
  • Start date Start date
G

GorKoUSA

I saved a query into worksheet1 that periodically retrievs data from
another worksheet2. When I try to start process of Refreshing Data and
both worksheets are already open on my PC a "Read Only" copy of
worksheet2 is ocasionally open and freezes.

When I make changes to worksheet2 and save it worksheet1 is still using
a read only copy that is not updated with my changes. If I fiddle for a
while with manual closing of the "read only" file eventualy it stops
appearing and everything works fine for a day.

How can I simplify the process of initial setup and avoid manual
closing of the unwanted file?

Georgee
 
You must log in or register to reply here.

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

Similar Threads

Copying the last used cell only 4
copy from dbf and paste to xls 1
Paste into next blank row in a different worksheet 10
Copying only new data to another worksheet 1
Slow code when used as VBA code instead of macro (copying visible columns) 3
Select Cell in first blank column of a row 2
Copy a row down a column for the same number of rows of data in another workshee 6
VBA Copy Range of cells with a condition to another worksheet 3

Back
Top