View Single Post
 
Old 10-02-2013, 05:53 AM
dirkswart dirkswart is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Oct 2013
Posts: 2
dirkswart is on a distinguished road
Default Excel 2010 changing external link formulas automatically on Webdav mapped drive

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?
Reply With Quote