#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Way

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 re

any idea how to solve the problem?

thanks!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Way to Summarize Linked Data with Pivot Tables

READ HE

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?

thanks!


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Way to Summarize Linked Data with Pivot Tables

Hi,

Try this, PivotTable, Table Options, check For empty cell show and leave the
box to its right empty.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Dominik" wrote:

READ HE

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?

thanks!


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Way to Summarize Linked Data with Pivot Tables

i had it already checked.
I think what I am looking for is some kind of IF formula that gives out a
value that pivot tables regard as empty. ="" is still counted, errors are
counted, too.

"Shane Devenshire" wrote:

Hi,

Try this, PivotTable, Table Options, check For empty cell show and leave the
box to its right empty.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,180
Default Way to Summarize Linked Data with Pivot Tables

Transfer data via a macro.
Blanks will stay blanks.

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



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

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"