Hello,
When using Jet express through Excel 2007 fields pulled through which had blank data in would show as "(blank)". We have now moved to 2010 and the data now pulls through as empty cells rather than "(blank)". Can this be changed? At the moment I would have to re write a fair few reports to compensate for this which I would rather avoid.
Thanks
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello JTURVEY06,
Are you referring to cells in the table created by an NL(Table) report (Table Builder) or in a Pivot Table?
Can you attach some screenshots of what you see in the two versions?
Is your goal to still show as "(blank)" as they did with Office 2007 or do you want the empty cells that the new version of Office shows?
When you say you would need to rewrite reports is this because you are Pivot Tabling off of the results of the table and this breaks your Pivot Tables?
If you are referring to Pivot Tables then you may want to review the following article.
The same Pivot Table setting is available for Office 2010/2013
http://www.techonthenet.com/excel/pivottbls/empty_cells2007.php
Best regards,
MWilson
Please sign in to leave a comment.