HI All
I have a shared workbook that has 7 users constantly using it daily, it has some formulas linked to another sheet on the netwrok drive, but because its a shared workbook i can create a macro to open the sheet it is calculating from, and it doesnt work by putting a hyperlink in there....
It works when i unshare it and put a macro in to open up the data sheet on activation, but i dont know how to get it to work when its shared?
Currently when its shared it returns #Value where the formulas are to a linked sheet
Could someone give me some advice please?
THanks
Dan
Bookmarks