LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 1
Default Links won't update unless both sheets are open...?

I have read some troubleshooting on this topic, but nothing that relates to my specific issue.

I have a master file and then four other spreadsheets that use formulas to update based on that master file. To pull the information from the master sheet, I am using IF(OR) formulas.

For months, these links worked and updated without issue. Then, one of the employees here who uses one of the "destination" sheets got a new computer, and now the links won't work unless both spreadsheets are open. At first, he was the only one who had the issue, then another employee who uses another "destination" sheet also got a new computer and is now having the same problem. Both employees went from Excel 2007 to Excel 2010, and I created all the spreadsheets in Excel 2007 and still have Excel 2007.

The weird thing is, I have not gotten a new computer, but I am also seeing the issue. But before they received new computers, everything worked fine.

So I don't know if this is an Excel or Windows issue, any thoughts?
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I update links from .xls sheets to .xlms sheets June Excel Worksheet Functions 2 April 21st 10 08:57 PM
Automatically use or update links between two sheets using VBA? Karti Excel Programming 4 February 25th 07 12:55 AM
How to update links between wk sheets nander Excel Worksheet Functions 1 August 25th 05 03:57 PM
Can you update links between workbooks without them both open? Nicolle K. Excel Discussion (Misc queries) 1 January 7th 05 08:39 PM
Update Links on file open Mick Southam Excel Programming 9 August 3rd 04 01:18 AM

All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"