Remove all Links and convert to General

**curtiswheat** · 06-02-2016, 10:05 AM

Looking for a script to remove all links in a workbook and format everything on all tabs to "General"

**mikeTRON** · 06-02-2016, 10:24 AM

So this removes the connections:

Please Login or Register  to view this content.

This will format each cell in all worksheets.

Please Login or Register  to view this content.

I also usually run some code to purge the cell STYLES because it is obnoxious when you have 60,000 of those and you want to use the default styles.

**curtiswheat** · 06-02-2016, 10:26 AM

Perfect! Do you have the code to purge as well?

**mikeTRON** · 06-02-2016, 03:09 PM

This is what I have in my personal macro.

Please Login or Register  to view this content.

Re: Remove all Links and convert to General