Refence other worksheet-#VALUE! error

  • Thread starter Thread starter plantslayer
  • Start date Start date
P

plantslayer

I have a number of worksheets linked. There is some that are not linking
properly but are showing up with a #VALUE! error in the cell. I have retried
reference the appropriate cell, formatting to General and Text. Nothing has
worked. Is there a formula within this cell that needs to be cleared to be
able to reference properly?
 
Hi,
This usually happens when a SUMIF tyype formula is trying to reference a
closed workbook. The solution is to either open the other workbook or change
the SUMIF formulas to SUMPRODUCT.

hth

Regards,
Bony
 
You must log in or register to reply here.

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

identical formula returns #VALUE! error 3
Excel VBA 1
Worksheet Formula Issues 3
Function to put worksheet name in cell returns text, need number 5
Value used in a Paste Link to remain constant during a sort 1
How do I lookup data from multiple worksheets? 2
Insert blank row after change in cell value not working. 1
Paste Values in linked Cells Only 4

Back
Top