"Dave Peterson" wrote
First, if you try to enter:
='results.csv!$B1
in a cell that's formatted as General (or anything but text), excel won't
let
you. It won't pass excel syntax checks.
So I'm still at a loss over what you're trying to do and what you're
trying to
fix.
You can create that format in a text document and import it though. Or you
can write it in if you format the cell for text.
The purpose is to allow you to switch between outside source documents.
You have an online document called
www.xxx.com/1/results.csv
You have refrences to that document eg =results.csv!$B1
If you close down the document and open
www.xxx.com/2/results.csv Excel will
replace all the links in te document like:
=results.csv!$B1
with something like
http://www.xxx.com/1/[results.csv]results!B1
However if you have a link called ='results.csv!$B1 that won't be affected.
So when you open the new results.csv, if you copy ='results.csv!$B1 into the
cell location then remove the apostrophe it will point to the new file. Or
it should.