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

You'll need a new app to open this about link 1
Embed the same Excel multiple times 0
Hyperlink fails to open on the first click 0
Copy and Paste Special in Excel #REF error 1
Visio shape text disappears upon copy paste 1
How Do I Avoid #REF! In Formulas? 5
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Excel - Wich Function should I use? 1

Top