Hello

Xaositect, whom you asked a question, hasn't been here in 7 months.

The node to which you replied is 6 years old.

Welcome, see The Perl Monks Guide to the Monastery, see How do I post a question effectively?, Where should I post X?

AFAIK, pivot tables are formulas, and

http://search.cpan.org/grep?cpanid=JMCNAMARA&release=Spreadsheet-ParseExcel-0.59&string=formula&i=1&n=1&C=0

says Also, formulas aren't rewritten, only the result of a formula is written.

meaning, you're running into a known limitation

Bye