yeah you have to read a macro for it
if its a link i think you press F9 to update
your you can refeesh the link every minute while its open

"LaKaroT" wrote:

Hi i have a spreadsheet that is automatically created at the end of the
working day we will call it "ssa.csv". I have created another worksheet that
sits there and pulls the data out of "ssa.csv" called "infomation.xls". I can
only update the infomation in "infomation.xls" if the file "ssa.csv" is open.