We help IT Professionals succeed at work.
Get Started

Why does Excel 2010 returns #Value error for cells referencing unopened linked spreadsheets.

dking_wri asked
Last Modified: 2012-05-12

My office is pilot testing a conversion to Office 2010 and I've noticed an issue in Excel that wasn't present in our 2007 installation. I'm getting  #Value errors in any cell that references an unopened linked spreadsheet. I can open the linked spreadsheet to resolve the issue but this isn't the most desireable solution.

It's odd that we didn't have this issue in 2007. Co-workers not in the test group are still running Excel 2007 and they can open the same file without the #value errors. I do have "Enable automatic update for all workbook links" checked and I realize this adds to the problem but I'm hoping there is another setting that we can modify to get back to the 2007 functionality. Any ideas?

Watch Question
Most Valuable Expert 2013
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
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
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