LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 16th 08, 10:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Nov 2008
Posts: 11
Default Summarize Linked Data with Pivot Tables

Excel 2003
Since there is no way to refresh pivot tables in a shared workbook, i have
created a second (not shared) workbook, identical to the shared one.
It contains links to all the cells of the shared files and pivot tables
summarising the shared (linked) data.
Later I would like to link the pivot tables of the unshared file back to a
little summary table in the shared file.

My Problem:
The pivot tables of the unshared file should summarise the linked data,
since every cell contains a link (formula), empty cells are counted by the
pivot tables .

I've tried to use If functions to set empty cells empty (if(xy < 0, xy, "")
but the pivot table still counts those cells.
Also, setting the pivot table count to countnum retrieves wrong values,
since some of the cess contain figures and some of them contain text.
Somtimes couloums dont contain empty cells at all.

any idea how to solve the problem? I guess I'm looking for an IF function
gives out a value, that is not counted by pivot tables.


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
Linked data tables won’t update automatically PaulH Excel Discussion (Misc queries) 1 October 21st 06 04:22 AM
Refreshing Pivot Tables linked to Oracle Datasource [email protected] Excel Discussion (Misc queries) 0 April 25th 06 12:15 AM
Renaming Cells linked to Pivot Tables gsimmons2005 Excel Discussion (Misc queries) 2 September 13th 05 03:51 PM
How to cause a pivot tables to not summarize data - just report the data Greybeard Excel Discussion (Misc queries) 0 July 27th 05 10:21 PM
How can I change the default way pivot tables summarize by Jorge Excel Discussion (Misc queries) 1 May 17th 05 02:45 PM

All times are GMT +1. The time now is 10:56 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017