Problem with linked workbook

  • Thread starter Thread starter polo
  • Start date Start date
P

polo

Hello,

I am an intern trying to finish a report on Excel... it uses an
sumproduct formula at one point which refers to data on another
workbook on the company server.

The formula works fine when the linked worbook is open on my computer.
But when I only open my REPORT workbook I get a REF error. I already
saved the linked workbook in the excel 2002 format and the path looks
perfect so that's not the pb....any suggestions?

Thank you very much for your help
 
I just tried a simple sumproduct formula and closed the workbook. The formula
continued to evaluate correctly (I hit F2 and then enter so excel recalculated
it).

Maybe it's not the =sumproduct() function that's the problem. You may want to
post your formula.

You may want to step through the formula (tools|formula Auditing|evaluate
formula) to see if you're references are really what you think they are.
 

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

How to create absolue path link to another workbook (Excel 2003) 1
Merge Multiple workbook sheets into one workbook 0
Excel Sumproduct Ref error when table is closed 0
Uisng the Max and Index function to link to other workbooks 1
Excel sum if and closed workbooks 2
Link to a password protected workbook 1
Link error #VALUE 5
Link behavior with changing data set 3

Back
Top