Destination workbook open, user opens source workbook = Links broken

모든 응답

• 2012년 6월 5일 화요일 오후 10:06

   

   
  

  0

  Hello,

  One of our users has some very complex excel spreadsheets (budgeting files). One of these spreadsheets is the destination workbook, and the rest are source workbooks. If the user is working in the destination workbook, and than opens the source workbook, the the link gets broken, specifically the referring part where it points to the sheet and cell after the path to the workbook. This did not happen in 2007, any ideas on how to fix it?

  • 병합됨 Max MengMicrosoft Contingent Staff, Moderator 2012년 6월 6일 수요일 오전 1:16
  •  
  • 응답
  • 인용

   
• 2012년 6월 5일 화요일 오후 10:34

   

   
  

  0

  See:

  http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2011/09/28/links-in-excel-are-broken-after-applying-security-update-ms11-072.aspx

  and

  http://support.microsoft.com/kb/925893

  HTH!

  David Hager

  Excel FMVP

  • 응답
  • 인용

   
• 2012년 6월 7일 목요일 오후 3:40

   

   
  

  0
  Sorry, i was having trouble posting for some reason that day, but anyway this occurs in office 2010 when the user opens up the destination workbook first, THAN opens the source workbook with the destination workbook still open. Thats when the user gets the #REF! error, and some of the information in the link has been removed. We just upgraded this user to Windows 7 and Office 2010.
  • 응답
  • 인용