How do I convert excel pivot tables to xls?

Asked By 20 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Jeremy J McPhail
Answered By 10 points N/A #165515

How do I convert excel pivot tables to xls?

qa-featured

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.

Best Answer
Best Answer
Answered By 50 points N/A #165516

How do I convert excel pivot tables to xls?

qa-featured

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.

 

Login/Register to Answer

Related Questions