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:

Professional Opinions
Ask a Question
Did 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

Avatar of PumpMeister
PumpMeister asked on
Microsoft ExcelSQL
9 Comments1 Solution369 ViewsLast Modified:
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.
Avatar of zorvek (Kevin Jones)
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers