Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2013, 05:53 AM
dirkswart dirkswart is offline Excel 2010 changing external link formulas automatically on Webdav mapped drive Windows 8 Excel 2010 changing external link formulas automatically on Webdav mapped drive Office 2010 32bit
Novice
Excel 2010 changing external link formulas automatically on Webdav mapped drive
 
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
  #2  
Old 10-07-2013, 12:36 PM
BobBridges's Avatar
BobBridges BobBridges is offline Excel 2010 changing external link formulas automatically on Webdav mapped drive Windows 7 64bit Excel 2010 changing external link formulas automatically on Webdav mapped drive Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 676
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

Dirkswart, I've never referred to an external workbook that's on a drive mapped to a web URL—I didn't even know it's possible—so I've been watching this space expecting that when someone else answered your question, I'd probably learn something new. But so far no one else has responded, which usually means no one else knows either. So I'll offer a guess:

When I'm creating external references, that is, references to other workbooks, as I said they're not on the web; they're always somewhere on my hard drive, or at most on a Sharepoint drive. But I have noticed that the external reference looks like this:
Code:
='C:\path\[filename.xls]SheetName'!A3
Then when I open the external target workbook, the reference changes automatically to
Code:
SheetName!A3
But when I close it again, the reference changes back. Now, is there any chance that this is all that's happening to you, that the style of the reference is changing but it changes back later?

I don't really have much hope for that, so here's a second question: After Excel changes the look of the reference, does the reference still work?
Reply With Quote
  #3  
Old 10-07-2013, 12:44 PM
dirkswart dirkswart is offline Excel 2010 changing external link formulas automatically on Webdav mapped drive Windows 8 Excel 2010 changing external link formulas automatically on Webdav mapped drive Office 2010 32bit
Novice
Excel 2010 changing external link formulas automatically on Webdav mapped drive
 
Join Date: Oct 2013
Posts: 2
dirkswart is on a distinguished road
Default

Nah, it changes it without any external workbooks open.
I once changed then back manually, only to find later that when opened, it just changed it straight back again.

It has something to do with the location of the source. It's somehow picking up that it's on a webdav mapped drive and changing the formula incorrectly.

Though it was something that one can turn off!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 changing external link formulas automatically on Webdav mapped drive 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
Excel 2010 changing external link formulas automatically on Webdav mapped drive Access pst files on external hard drive LOUDONCLEAR Outlook 1 09-22-2011 06:13 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft