PivTbl source: Can be linked cell? formula?

  • Thread starter Thread starter Strasser
  • Start date Start date
S

Strasser

Source for PivTbl is an Excel "List" (simple database format).

One of the fields (columns) in the database is a calculated field (it
is a formula, not a regular number).
Another column is a linked field.

Do I have to copy the list and use Paste Special > "values only" to
change the calculated/linked fields to a regular number fields (instead
of a formula field or linked field) BEFORE creating a Pivot Table from
the "List"?

Or, will the Pivot Table work OK using a formula/linked fields in the
database "List" source ?

Thank you in advance!
 
Hi

No problem using calculated fields (columns).
Just go ahead and create your PT based upon your table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot table formulas 1
Calculates field in pivot table 2
Mystery field in pivot table 8
Formula fields in Pivot Tables? 1
Summing Formula fields in Pivot Tables? 3
Formula fields in Pivot table reports? 2
Pivot table, IF function, calculated item versus calculated field 1

Back
Top