Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
Troubleshooting
Research
Professional Opinions
Ask a QuestionDid You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
troubleshooting Question
Eliminating error messages when an external data connection is unavailable in Excel 2007
PumpMeister asked on
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.
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.