I have a spreadsheet that has some data connections to an Access db on a shared network drive. My users would normally use this spreadsheet locally or via VPN. However, I would also like to allow them to use it when they cannot connect to the network or VPN in.
In this situation, the user would just be using the last query results obtained from the Access db...no refresh since the data connection to the Access db is not active.
However, in testing this scenario, I am seeing a lot of error messages from excel about the missing data source. These messages would be very disconcerting to the users of the spreadsheet.
Is there any way to trap or eliminate these error messages?
I am very VBA savy, so if it requires a VBA approach, that is fine.