How to get full path of cross-sheet references?

[angus chao]

I can get the path of cross-sheet references from the cell formula. But some have a full path and some don't. The actual path of [Document.xlsx] is in 'D' drive [D:\Document.xlsx].

[Sreemon Premkumar Muthukrishnan]

Hi angus chao, 

We have investigated the reported issue from our side but were unable to replicate the scenario as described. We have attached our tested sample for your reference. Could you please provide more information regarding the reported issue? If possible, could you modify the provided sample and share it with us?

This would be helpful for us to replicate the issue accurately and provide a solution as soon as possible.

Regards,

Sreemon Premkumar M.

Attachment: Spreadsheet__3f211ba2.zip