How to link sheets/cells over web

J

Juha

So the questions is as follows:
I have a loads of different excel workbooks which are linked to on
"total"sheet that gathers the information from all sheets. Now I hav
to store them into a web folder and I can't link them the way I hav
linked them now. Now the formula is like this
'C:\=[Book2.xls]Sheet1'!$A$1. And now when I put them to this we
folder every workbook get its own http address and I should someho
change the path C:\... with web address.
Is it possible and how?
Thanks
 

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

Top