Replies

To avoid truncation, first create a blank workbook with the number of worksheets you need. Then go to the source worksheet, Select the sheets you want to copy. Do this by holding down the control key and clicking on the sheet tabs. If you want all sheets, right click and select all sheets. Then select all cells on the first sheet by clicking on the box immediately above the row 1 label and left of the column A label. Do a copy. Then go to the first sheet in the destination workbook and click on column A. No need to select sheets. Now do a paste. The paste will be done and multiple sheets selected. Right click on the sheet tab and select ungroup.

If you are copying charts, the chart references will be back to the original workbook. Save the destination workbook. Then do edit links, select the source workbook and change links to the destination workbook.

Bob Flanagan
http://www.add-ins.com

Just an additional thought. If you have any COM add-ins running and don’t need (few are ever needed), they can cause Excel to run out of memory. To remove in Excel 2007, select Office Button, Excel Options, Add-ins. Change Manage Excel add-ins to Manage COM add-ins and then click Go. Uncheck all you do not need.

If you are using HP printers, we have had reports that they cause memory/display problems. We switched to Brothers and Canons and have not had problems.

Lastly, exiting Excel every hour or so tends to avoid issues.

Bob Flanagan
http://www.add-ins.com

We have just released a free tool for XP, Vista, and Windows 7 called the Shortcut Maker. It makes adding shortcuts to the XP classic menu very easy. Just right click on a folder, file, program, or shortcut and select Shortcut Maker from the context menu. Select the destination folder for the shortcut and click OK. Then, when you want to access the target, just click on the Start menu, highlight the folder, and click on the shortcut.

The Shortcut Maker suggests you create your shortcuts in folders named Favorite Folders, Favorite Programs, Favorite Links and Favorite Files. If these folders are not on the XP Classic menu, it will ask if it can create them for you. You can create a shortcut anywhere you want. Other selections available are the Desktop, the SendTo menu, and any folder found on the start menu.

If you are viewing a folder and want a shortcut to it, just right click on the white space of the folder and select Shortcut Maker.

To add shortcuts to your favorite programs to the Favorite Programs folder, just click Program Files, go to the program in the menu structure, and right click on the shortcut to the program and select Shortcut Maker.

If you have the File Open dialog open or the File Save dialog open you can right click on a file or a folder (or the folder white space) and use Shortcut Maker to create a shortcut.

You can delete any shortcut you create by just right clicking on it. You can re-organize the shortcuts in any order by just dragging and moving.

If you are using Windows 7, they you will need to first install Classic Shell from Source Forge. If you are using Windows Vista, then you should change to the XP Start Menu. Instructions for doing so are found on the Shortcut Maker page, along with a link to Classic Shell for Windows 7 users.