Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Can I stop Excel auto entering GETPIVOTDATA functions into formula

This is very irritating when entering formulas that reference pivotted data
in Excel. Can one turn this off?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default Can I stop Excel auto entering GETPIVOTDATA functions into formula

Hi Francois

Take a look at Debra Dalgleish's site for more help on this
http://www.contextures.com/xlPivot06.html

--
Regards

Roger Govier


"Francois" wrote in message
...
This is very irritating when entering formulas that reference pivotted
data
in Excel. Can one turn this off?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I see the formula calculation used in Excel functions box Angela Excel Worksheet Functions 2 April 28th 06 05:49 PM
Can excel recognize a word and auto format a formula, on diffe she brooke Excel Worksheet Functions 0 October 20th 05 08:11 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Why not nest more than 7 functions in Excel formula??? GrandCentral Excel Worksheet Functions 9 March 31st 05 09:30 PM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"