ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help please never come across this problem before (https://www.excelbanter.com/excel-discussion-misc-queries/169886-help-please-never-come-across-problem-before.html)

Cal Hayes

Help please never come across this problem before
 
Hi Everyone

Hope someone can help with this problem - I have created a very simple spreadsheet in Excel 2003 there are 4 columns

A = Code No
B = Qty
C = Price per 100
D = Value

at the bottom of column D there is a grand total. The spreadsheet works fine on my computer however when I email it to the firm that needs it the total is not shown in the screen or printout. Only when they hover the mouse over does the total appear.

I would be grateful if anyone can suggest possible causes for this and a remedy. I thought the problem may be that they are using an earlier version of Excel I have emailed them requesting to know which version of Excel they are using - still awaiting a reply.

Any help would be most gratefully received
Yours in Anticipation
Calvina Hayes

Roger Govier[_3_]

Help please never come across this problem before
 
Hi

What do they see in the cells, prior to hovering with the mouse?
If it is a series of #####, then it sounds as though the column is not wide
enough to display the result.

Hover the mouse over the intersection of column D and E, and double click
and it will widen to accommodate the largest value within column D.

--

Regards
Roger Govier

"Cal Hayes" wrote in message
...

Hi Everyone

Hope someone can help with this problem - I have created a very simple
spreadsheet in Excel 2003 there are 4 columns

A = Code No
B = Qty
C = Price per 100
D = Value

at the bottom of column D there is a grand total. The spreadsheet works
fine on my computer however when I email it to the firm that needs it
the total is not shown in the screen or printout. Only when they hover
the mouse over does the total appear.

I would be grateful if anyone can suggest possible causes for this and
a remedy. I thought the problem may be that they are using an earlier
version of Excel I have emailed them requesting to know which version
of Excel they are using - still awaiting a reply.

Any help would be most gratefully received
Yours in Anticipation
Calvina Hayes




--
Cal Hayes



Cal Hayes

Hi Roger,

Thanks very much this was indeed the problem the column wasn't wide enough. I am very grateful to you.

Compliments of the season.

Kindest Regards
Calvina Hayes

Quote:

Originally Posted by Roger Govier[_3_] (Post 600384)
Hi

What do they see in the cells, prior to hovering with the mouse?
If it is a series of #####, then it sounds as though the column is not wide
enough to display the result.

Hover the mouse over the intersection of column D and E, and double click
and it will widen to accommodate the largest value within column D.

--

Regards
Roger Govier

"Cal Hayes" wrote in message
...

Hi Everyone

Hope someone can help with this problem - I have created a very simple
spreadsheet in Excel 2003 there are 4 columns

A = Code No
B = Qty
C = Price per 100
D = Value

at the bottom of column D there is a grand total. The spreadsheet works
fine on my computer however when I email it to the firm that needs it
the total is not shown in the screen or printout. Only when they hover
the mouse over does the total appear.

I would be grateful if anyone can suggest possible causes for this and
a remedy. I thought the problem may be that they are using an earlier
version of Excel I have emailed them requesting to know which version
of Excel they are using - still awaiting a reply.

Any help would be most gratefully received
Yours in Anticipation
Calvina Hayes




--
Cal Hayes



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com