Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2016, 04:47 AM
Phil H Phil H is offline Macro to Dismiss Links to Corrupt Workbook Windows XP Macro to Dismiss Links to Corrupt Workbook Office 2010 64bit
Advanced Beginner
Macro to Dismiss Links to Corrupt Workbook
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default Macro to Dismiss Links to Corrupt Workbook


iMAC with OS 10.14

Workbook1 with macros is corrupt (believe macros the reason for corruption, though not sure - getting not enough memory messages. Cannot change cell entries or save file. Have used workbook1 for a long time with no issues, then suddenly this problem.

Created Workbook2 and copied worksheet1 from workbook1 into worksheet 1 of Workbook2. Workbook2 is not corrupt, works fine, saves okay, no error messages, does not have the macros.

On opening workbook2, a message comes up asking to establish links to workbook1. If answered Yes corrupt workbook 1 opens and closes workbook2. Am answering No, workbook2 opens and functions properly.

Plan to copy macros from workbook1 to MS Word, and then copy from Word to workbook2 (haven't done this yet), - hoping this intermediate step eliminates any corruption source in the macros. Is this correct thinking?

Is there an on-open macro I can use in workbook2 dismissing the message and any linking to the corrupt workbook1?
Reply With Quote
  #2  
Old 04-20-2016, 10:34 PM
macropod's Avatar
macropod macropod is offline Macro to Dismiss Links to Corrupt Workbook Windows 7 64bit Macro to Dismiss Links to Corrupt Workbook Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If Workbook1 is opening & displaying correctly, it is unlikely to be corrupt. More likely, you have a coding error in the macro causing it to consume all available memory. Copying the macro to MS Word won't resolve that.

As for the links issue, that's most likely because you copied formulae referencing a different sheet from Workbook1 to Workbook2. You can use Find/Replace to delete the references to Workbook1.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
corrupt workbook, linking, memory

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Dismiss Links to Corrupt Workbook One macro to sort individual sheets in a workbook darbybrown Excel Programming 1 09-11-2016 12:51 PM
Macro to Dismiss Links to Corrupt Workbook How to dismiss/avoid warning/alert dialog boxes in Microsoft.Office.Interop.Word.Document meenagrace Word VBA 3 11-07-2014 01:29 PM
Macro to Dismiss Links to Corrupt Workbook We can't update some of the links in your workbook right now theRunner Excel 1 03-03-2014 10:42 AM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM
Macro to Dismiss Links to Corrupt Workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 AM.


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