Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Avi Avi is offline
external usenet poster
 
Posts: 9
Default empty values for a specific field

I have a pivot table (excel 2003) based on mulitple tabs (more than 65.536
rows) which worked fine until recently.
One specific field shows no values, but only from one tab, so in the pivot
table there is a clientname with a clientnumber, but the same client also has
an empty 'clientnumber' field where there should be a value.

I checked the sourcedata and nothing has changed: it still shows the
clientnumbers in the first tab, but when I doubleclick a value in the
pivottable (where the clientnumber is empty) it also shows no value for the
clientnumber.

All other fields do show their values (at least, I think they do, because I
really can't trust my pivottable anymore).

I tried the 'ResetPageCaptions'-macro by Debra Dalgleish but to no avail.
They still won't show the values.
I also renamed the fieldname in the 5 sheets of sourcedata to maybe force
the pivottable to reread the info, but the pivottable still shows the old
name???
Then I tried to rebuild the pivottable by going into the wizard and
selecting the five sheets as sourcedata all over again, but then I get an
error saying something like 'unkown database-format C:\filename.xls' (don't
know the exact message, since I don't have an english version) so I can't
even get into the query.
Making a new pivot table in a new file will give the same errormessage.

Please help me.
Arnold.
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
Sum only if corresponding field is not empty [email protected] Charts and Charting in Excel 2 April 11th 06 02:01 PM
Go to Next Empty Field cassy01 Excel Discussion (Misc queries) 1 February 20th 06 11:18 AM
Hide empty field error J Excel Worksheet Functions 3 June 28th 05 05:10 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 7 May 17th 05 02:22 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 2 May 15th 05 05:32 PM


All times are GMT +1. The time now is 10:49 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"