Help please never come across this problem before

C

Cal Hayes

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
 
R

Roger Govier

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.
 
C

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

'Roger Govier[_3_ said:
;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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top