Thursday, January 18, 2007

Cannot edit a PivotTable in group edit mode

What to do if this message comes up in Microsoft Excel?

Right click on a sheet and select Ungroup Sheets or click on one of the sheets that is not selected.

If you don't know what group edit is, here is a little explanation from the help file on "Edit data on multiple worksheets".

When you select several worksheets and then change the data on one of them, the changes are applied to the same cells on all the selected worksheets.

And a nice note that can be useful.

When you edit data, the changes affect all selected worksheets and may inadvertently replace data that you didn't mean to change. If needed, you can view worksheets at the same time:

  1. On the Window menu, click New Window.
  2. Switch to the new window, and then click a worksheet that you want to view. Repeat for each worksheet that you want to view.
  3. On the Window menu, click Arrange, and then click the option that you want.

To view worksheets in only the active workbook, select the Windows of active workbook check box.

Technorati tags:

Some of the latest blog posts

Subscribe to RSS headline updates from:
Powered by FeedBurner