Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot tables and illegal operations

Status
Not open for further replies.
brunei

brunei

MIS
Oct 10, 2000
54
US
I'm getting an error in Excel 2000 when I switch between my worksheet and a pivot table I've created. It says that I have performed an illegal operation and then proceeds to close out of Excel. Needless to say I lose all the information I was working on.
 
Sort by date Sort by votes
Have you tried recreating the pivot table and just deleting the old one? (Consider yourself lucky that you even got me to say "pivot table". I hate them. Haha!)
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Pivot Table Issue
Replies
6
Views
222
Andrzejek
Andrzejek
remeng
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
999
remeng
remeng
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
485
combo
combo
R
  • Question
Issues with Outlook default account and performance
Replies
0
Views
193
radleymartinez
R
cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
328
cneill
cneill

Part and Inventory Search

Sponsor

Back
Top