Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WHEN I SAVE EXCEL WITH FORMAT ...

Status
Not open for further replies.

martine

Technical User
Jan 15, 2001
32
CA
Hi,

I have a problem. I make a report and when I save in excel with format, many totals in excel replace by a blank... Why? How I can fix this...

Thanks!

Martine
 
Martine,
Sounds odd.
Just to clarify, regarding the totals that are visible in impromptu:
are they
1) in columns or in group headers/footers.
2) missing from excel completely
3) shown in excel as zero
4) not immediately visible in excel, due to justification, but are in a cell?
Perhaps you could post an example with some detail?
lex
 
HI,

I have a total in the footer in impromptu (I just in header / footer) but in excel ... Its a blank ... I don't have a zero ....

Martine
 
Martine,
Wonder whether it's a format/properties glitch?
Quick test with a short report with a numberical column:
click on the column title of a numerical column and then click on the Sigma (sum) button, the report should put a total in the footer under the column. Save this to excel and see if the total is present.
lex
 
Yes its present ....

how can I put a print screen ... for the example
 
Martine,

Since the test worked, then it must be a layout issue. Could you not now just clear the footer and then re-insert the total(s) ?
lex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top