I have two spreadsheets linked by INDEX/MATCH call them Calculations and Data. On opening Calculations I am now getting an error saying - Sorry we couldn't find a link to an irrelevant shqrepoint file. The odd thing is there is no shareponint document involved. I selectively deleted all cells on the Calculations spreadsheet until I found the cells casuing the error and it was my INDEX/MATCH formulae. These look to cells in the Data spreadsheet stored on our server - not on any sharepoint source. Googling I found a possible solution that the data path can't exceed 254 characters but mine is shorter. I have tried manually re-writing the formulae - using Data/Edit and moving files onto my laptop - nothing worked. Interestingly I get the same error once on my laptop.
Any help or advice would be gratefully received.
Simon
Bookmarks