Hello, I tried to link the following cells to each of the spreadsheet. However, 2 of them (ProductCatalog, MaterialCost) work while the others (Sales, Profit, Help) don't. When I clicked the hyperlink, it displays "Reference is not valid"
right click-> edit hyperlink->click the excel file 'SalesTracking.xlsx' -> Address: SalesTracking.xlsx#Sales
ProductCatalog
Sales
MaterialCost
Profit
Help
I do appreciate if anyone can help with it.
Last edited by Stella2012; 08-06-2012 at 10:41 AM.
can you attach the worksheet or a sample of it? Might help us to see better
Book1.xlsx
I made an example, however it didn't work totally
hello
try this one..
right click-> edit hyperlink->click the "Place in this document" ->choose sheet names
not this:
right click-> edit hyperlink->click the excel file 'SalesTracking.xlsx' -> Address: SalesTracking.xlsx#Sales
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks