Help please never come across this problem before

  • Thread starter Thread starter Cal Hayes
  • Start date Start date
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
 
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.
 
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

Back
Top