Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table

Pivot Table

ResolvedVersion 2010

Fri 18 May 2012, 12:04 Delegate Bital said...

Bital has attended:
Excel Intermediate course
Excel Advanced course

Pivot Table

Hi,

How can i make the pivot table inactive so that i can use the data from the table in my calaculations with out it giving me a long cell reference in my formula?

thanks

Mon 21 May 2012, 10:15 Trainer Anthony said...

RE: Pivot Table

Hi Bital, thanks for your query. You need to turn off the GETPIVOTDATA function. It lives on the Pivot Table Options tab, on the left hand side in the Options drop down. Just make sure it isn't ticked and you'll be able to use your Pivot data as normal.

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Pivot Table

Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Importing Numbers in Excel 2010