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?