#REF errors in links

S

srinivasan

I have a workbook with links to many worksheets in separate files. Each year
I used to change the source files to the corresponding year and the links
work fine. Now all of a sudden this year when I change the source file the
links shows #REF. I don;t know?Why.But the formula is displayed correctly and
the result is shown as #REF.Some one may help.
srinivasan
 

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

Copy and Paste Special in Excel #REF error 1
VLookup Won't Copy down (#REF! error) 1
Link To File That No Longer Exists 1
Syncing between source worksheet and dependent worksheets 0
Id'ing tabs that contain #REF!'s 19
Formula addition causes random #REF! 1
Links to Dynamic Named Range = Problem 8
Indirect formula errors if file is closed 0

Top