Hi all,
I have got a workbook with several queries that auto refresh every 5 min. After the refresh the file is saved by the macro. Sometimes i will check the file to see if its still function and i will see the error: file is in use try again later. where i have to press ok to have the routine continue.
This is always open on a remote desktop. other users will get data though this file. When they open their dashboard the data will be update through: update values.
My guess is that the error occurs when a user updates their values at the same time the macro is trying to save the workbook with the queries.
Does anyone know a solution for this. i.e. have the routine continue after the error. I already added application display alerts and on error resume next but it does not help.
The only thing i can think about is having the file close and reopen itself on a set interval?
Any help would be appreciated.
Bookmarks