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

No. The shortcut in My Folder is simply that, a shortcut to the actual file
which resides on the C drive. Nothing is actually being opened from the
MyFolder.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kevin" wrote:

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