Posted to microsoft.public.excel.charting

Hendry Del Fuego Hendry Del Fuego is offline

external usenet poster

Posts: 1

reference of PivotTable

Hi all,

I am struggling with the following problem:

I want to use the following formula:
=OFFSET('Sheet1 (1)'!$C$2;1;0;COUNT('Sheet1 (1)'!$C$3:$C$2008);1)

very easy but this doesnt work. Why, because C2 is a field of a Pivottable
and apparently Excell doest see this as a reference cell.

any ideas how to solve this?

Best regards
Kenny

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
pivottable on web	tikchye_oldLearner57	Excel Discussion (Misc queries)	0	February 22nd 07 11:17 AM
Excel 2007 PivotTable "arbitrary shape is not allowed when its elements cross a reference dimension"	Michael	Excel Discussion (Misc queries)	0	July 20th 06 06:00 PM
PivotTable	Penguin817 via OfficeKB.com	Excel Worksheet Functions	1	May 18th 06 02:53 PM
function to reference all of pivottable data field array	andrew	Excel Worksheet Functions	0	February 22nd 06 05:54 PM
Pivottable	johnb	Charts and Charting in Excel	0	November 29th 05 10:53 AM

All times are GMT +1. The time now is 11:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us