|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing Video Link Paths | julianpaul | PowerPoint | 4 | 09-03-2012 01:55 AM |
How to link an object to a URL link to update automatically | expert4knowledge | Excel | 1 | 06-11-2012 09:30 AM |
Powerpoint automatically changing picture size when adding a picture (2010) | One_Life | PowerPoint | 7 | 01-20-2012 06:57 AM |
Hyperlinking files on a mapped network drive | howler2345 | Outlook | 0 | 12-21-2011 08:54 AM |
Access pst files on external hard drive | LOUDONCLEAR | Outlook | 1 | 09-22-2011 06:13 PM |