View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default CELL("filename") doesn't work on shortcut workbook link?

Hi,
I got a shortcut link of master workbook and I"m trying to find the location
of shortcut linked file.

E.G.
1) C:/master file.xls
2) C:/MyFolder/shortcut to master file.xls

Now when I add this formula to shortcut file =Cell("filename") it shows
C:/master file.xls but I'm interested in C:/MyFolder/shortcut to master
file.xls .

Is it possible?

Thanks
Kevin