Excel remembers that you recorded a macro in the workbook. Unfortunately, Excel keeps asking you to enable macros when you reopen the workbook even though you have deleted all the macros. There are a few things you can do to fix this issue.
Author: BrainBell
Workbooks sometimes become corrupt for no apparent reason. This can cause all sorts of problems, especially if the workbook is vital and for whatever reason you have no backup. Fortunately, there are some ways to try to repair or extract data from a corrupt workbook.
How to Reduce Workbook File Size
Ever notice that your workbook is increasing in size at an alarming rate for no apparent reason? There are several causes of workbook bloat and some slimming solutions. Workbook bloat is a term for a workbook that has had so much done to it that it has swollen to such a size it can no longer function correctly.
Remove Phantom Workbook Links
You open your workbook and are prompted to “Update Links,” but there are no links! How can you update links when they don’t exist?
Cell References
Relative and absolute references are two types of cell references in Excel formulas. A relative reference is a cell address that changes when you copy or move the formula to another location. An absolute reference is a cell address that stays the same no matter where you copy or move the formula. These references allow you to use spreadsheets effectively and efficiently.
Find and Remove Duplicate Data
People frequently have to identify duplicated data within a list or table. Doing this manually can be very time-consuming and error-prone. To make this job much easier, you can learn one of Excel’s standard features, conditional formatting.
Lock and Protect Cells Containing Formulas
You may want to let users change cells containing data without providing them access to change formulas. You can keep cells containing formulas under lock and key without having to protect your entire sheet or workbook.
If you move around your spreadsheet a lot, or if you have data you don’t want readers to explore, you might find it convenient to limit the visible area of your spreadsheet to only that which has actual data.
Create an Index of Sheets in Your Workbook
If you’ve spent much time in a workbook with many worksheets, you know how painful it can be to find a particular worksheet. An index sheet available to every worksheet is a navigational must-have. In this tutorial, you’ll learn to create an index in a couple of ways.
If you work on the same workbooks each day, you can make these workbooks open automatically whenever you start Excel.