external sheet references
How to remove the references to the external file, is It by double clicking like you mentioned in "Be even quicker: f5+ enter" ?
Please explain again, with every step.
1 answers ( 0 marked as helpful)
There are two main ways to do this. One is to copy the name of the external file and to use Find and Replace and change formula references to the external file. This is how I usually do this.
The second (more traditional) option is to the Data tab and click on Edit Links. Here you can replace the links to the External file.
Submit an answer
Resolved: How do the Xs help you go faster to the bottom of your sheet as you say?
Multiple Print areas : Is it possible to create multiple print areas within a single sheet ?
How did he remove all the borders from the whole sheet? I miss that part, one video they were there