query to another spreadsheet

joecast

Board Regular
Joined
Mar 4, 2010
Messages
52
hello all,

i have a spreadsheet (view) set up to query data in a second spreadsheet (data). the purpose of this is to allow many users in different locations to update 'data' while another group of users in other locations view and refresh 'view'.

if 'data' is open when refreshing 'view', a read only copy of 'data' opens in the application view' is in. how do i stop this happening? i would prefer a message popup saying "'data' is being updated, please try to refresh later". is this possible?

thanks!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

joecast

Board Regular
Joined
Mar 4, 2010
Messages
52
so is there a way (via vba macro) to check if another file is open before running the query? might google that...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,169
Members
410,775
Latest member
alal1030
Top