Forum Discussion
Stop SharePoint Online hosted linked Excel file displaying absolute path in formulas
Hi All I have a series of linked Excel workbooks hosted in SharePoint Online - Test 1 and Test 2 for the purposes of the below. If I have both the files open, the formula's in Test 1 (target)...
SvenM1005 is it ok/acceptable that the cell only updates when the other sheet is open? If so you can use INDIRECT() function.
mtarler thanks for the reply. Not really I'm afraid - these are a series of linked financial data sets so having to open them all to update would risk the data potentially being wrong (not updated but taken on face value). Additionally if all the sheets were open, the issue is negated anyway as it shows relative links (or just workbook name) if the source sheet is open.