Weird Error with Arrays

L

lj

Hi, I encountered a really weird error in many of the cells in my
workbook when I opened excel this morning - all of the formulas that
used a sum if array linking to another file were broken. They all
have ={#N/A} showing as the formula for the cell and either the most
recent value is actually displayed in the cell or #N/A is displayed in
the cell. Other cells that were linking to the same file that the ones
with errors in them were but had index formulas were fine. I use
excel a lot and am in it all the time and have never had this
problem. Any ideas of what happened? I used this file last night
right before I went home and everything seemed fine, and this issue
appeared as soon as I opened excel this morning. This is really
frustrating me. Please Help

Lisa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Create a chart from a table in word thats dynamic 0
Dealing with the error: unable to filter on excel hc home school 0
Cumulative formula for word table 0
Embedded Excel into Word with Tables 0
Merging from an Excel file with graphics 1
Cannot access to Office Insider 0
Working outlook via vba code with xlsx - error 0

Top