Open a spreadsheet with links, don't update and get # values

M

Miles

I'm opening a spreadsheet with links to another in the
formulas and I'm offered the option of updade or no
update. When I choose no update I get a # value error.
One of the formula's is =SUMIF('C:\Documents and
Settings\milesg\Desktop\[Split.xls]Worksheet'!
$A:$A,B$3,'C:\Documents and
Settings\milesg\Desktop\[Split.xls]Worksheet'!
$K:$K)/1000000

The spreadsheet was created in 97 and I've had this in
both 2002 and 2003.
 

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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Open multiple spreadsheets and pull data 0
Multiply with Vlookup value from another Worksheet 0
#VALUE error on SUMIF formula linked to multiple worksheets 1
Match two values 2
Finding the weighted average of text that have been given values 1
User is not prompted to update links when opening spreadsheet 2
Linking excel to word 2013 - Error! Not a valid link 0

Top