Excel spontaneously changes reference to linked workbook

kafka

New Member
Joined
Jun 2, 2012
Messages
30
I have a cell in a worksheet which is linked to a cell in another workbook. In theory the link should update when I open the first workshheet, however the linking formula has changed itself to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link directly to a cell in a workbook in my D: drive and ,because it doesn't, the result in the cell is outdated. I have manually changed the formula to directly link to the appropriate cell but Excel simply changes it back. Help!
 

kafka

New Member
Joined
Jun 2, 2012
Messages
30
Afte trying again to link spreadsheets I have finally been successful (though I don't know why).
 

kafka

New Member
Joined
Jun 2, 2012
Messages
30
No, I haven't been successful. The linking formula has changed itself again to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link directly to a cell in a workbook in my D: drive
 

kafka

New Member
Joined
Jun 2, 2012
Messages
30
I gather that nobody has an explanation for this phenomenon. My latest idea is to change the linking formulas back to what they are supposed to be (see earlier posts) then password protect the worksheet. Maybe this will stop Excel from changing the formulas.
 

kafka

New Member
Joined
Jun 2, 2012
Messages
30
An update. In an attempt to solve my problem I created a macro which recreates the two links each time it is run. While washing up this morning a possible reason for the problem popped into my head. When setting up the links I have always opened the second workbook by selecting it from the list of recently opened workbooks which appear when I click on Files Open. It occurred to me that Excel might be confused if, days later, it didn't find the desired workbooks in the recently opened files list. As well as the aforementioned macros, I have now linked to the other workbooks by selecting them directly from My Computer. I will see which of the methods work (if either does).
 

Forum statistics

Threads
1,081,537
Messages
5,359,380
Members
400,526
Latest member
Brook1083

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top