How do I convert excel pivot tables to xls?

Asked By Christine Turner 20 points N/A Posted on - 02/26/2013

How do I convert Excel pivot tables to XLS? 

I tried saving it on Excel but I can't edit it because it's in a read-only state. 

I'm on Windows Vista 64 bit and Microsoft Excel 2003. 

Is this a compatibility issue?

• Status: Open
• Question Views: 1933
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Jeremy J McPhail

Go To Solution

Answered By Keith J Harmon 10 points N/A #165515

How do I convert excel pivot tables to xls?

Dear Cgristine,

In the Pivot table wizard click ALT + D to create Multiple Consolidation Ranges PivotTable." then select I'll "create my own page fields". Select your data and double click on the grand total value.

You will see a new sheet containing all of the data in your pivot table.

Now you can edit your sheet and save it as XLS.

About Keith J Harmon

Questions
9

Answers
61

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 03/14/2013
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Jeremy J McPhail 50 points N/A #165516

How do I convert excel pivot tables to xls?

Hello, Christine

Hope you are fine. You want to convert the pivot table to XLS. There are three steps to convert pivot tables to XLS.

Just click below.

Three steps

Here you will see 3 steps with image and also a video to learn to convert pivot tables to XLS.

You also can try this link.

Video for better understanding

Hope you will get your answer.

 

About Jeremy J McPhail

Questions
10

Answers
106

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 03/28/2013
• Question Category: MS Excel