I am having a problem with an external link showing the path of the link
instead of the value. For example it shows ='[Sales
Forecast.xlsx]January'!A2. When I first create the link it shows the value,
but once I remove the absolute reference from the linked cell it shows the
path. This is only happening with one of my workbooks that I link to. All the
other workbooks I link to work just fine. How do I get this workbook to show
the value instead of the path?