I have an extremely large worksbook with over 350 worksheets and over 5.5mb. There are tons of macros I use. It taker a long time to load. I need opinions tgo speed up loading the workbook. I'm considering placing this code when the workbook launaches:
Application.Calculation = xlCalculationManual
and place this code when the worksheet launches and closes:
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Workbook link problems after copying tabs to a new workbook?
David Miller (dlmille)
Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…