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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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,069
Messages
5,545,803
Members
410,708
Latest member
SanTrapGamer
Top