Hi Pls can someone help me. Using Excel 2010 and have multiple workbooks with formulas referencing each other. The data is stored on a webdav(http) mapped drive and is visible on the PC as L:

Example of the formula in the workbook:
='L:\2013\Daily figures\A\[10-October.xlsx]1'!$D$9

Drive is mapped as such:
L:\ mapped to http://www.drivehq.com/webdav/expressfinance

When opening the spreadsheet at times the formula changes by itself to:
='http://www.drivehq.com/2013/Daily figures/A/[10-October.xlsx]1'!$D$9

The source document is located on L: so this works but when it changes to the http formula by itself is obviously inaccessible.

I even edit the formulas and change it back to L:\..... then Excel just puts back the http: into the formula.

Pls does anyone know why?