Creating Workbooks

Tips, Tricks, and Answers

The following articles are available for the 'Creating Workbooks' topic. Click the article's title (shown in bold) to see the associated article.

Creating a Workbook Clone
You can use the standard Open dialog box to open a copy of whatever worksheet file you want. That way the original file remains undisturbed, and you do your changes on the copy.

Workbook, Once Created, is Too Big for Memory
Understanding how Excel uses memory, how much it allows, and how to work around the limitations.