how can you freeze links in excel? no #Ref upon opening the file?

I

Incognito

I have included quite some links in an excel file, however, upon opening the
file, these links turn into #REF when the linked file is not opened; Is there
any way to freeze the links?
 

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

#REF issue with links 0
Links to Dynamic Named Range = Problem 8
Excel 2003 - #REF! in Links 3
Excel How to Fix Damaged Excel File That Won't Open? 3
Link To File That No Longer Exists 1
How do you make a userform open automatically when you open excel? 1
Excel-links in worksheet shows #Ref 4
Excel links in Word 1

Top