Zero Values
 

Hello

I've got a spreadsheet which I regularly update and email to others
for their use. In every version, it's always set up with the 'Zero
Values' box unchecked.

When the others open the spreadsheet from their email, zero values are
showing. Also, with one particular user (who uses the same printer as
me), the pages of her spreadsheet are longer than they should be so
hers won't print on 2 pages as it should, the bottom of each page is
'hanging over' on to the next one so she gets 4 pages.

Any clues?

Thanks
R

Zero Values
 

The individual users need to set display zero condition. With the printer
problem, it is possible that the other user does not have the correct paper
size selected in the printer setup. Need to select the printer from the
Control Panel and check. If that does not fix the problem then in Excel Page
Setup maybe set Fit to 1 page wide by 2 tall.

--
Regards,

OssieMac


"robzrob" wrote:

Hello

I've got a spreadsheet which I regularly update and email to others
for their use. In every version, it's always set up with the 'Zero
Values' box unchecked.

When the others open the spreadsheet from their email, zero values are
showing. Also, with one particular user (who uses the same printer as
me), the pages of her spreadsheet are longer than they should be so
hers won't print on 2 pages as it should, the bottom of each page is
'hanging over' on to the next one so she gets 4 pages.

Any clues?

Thanks
R

Zero Values
 

On Mar 29, 11:24*pm, OssieMac
wrote:
The individual users need to set display zero condition. With the printer
problem, it is possible that the other user does not have the correct paper
size selected in the printer setup. Need to select the printer from the
Control Panel and check. If that does not fix the problem then in Excel Page
Setup maybe set Fit to 1 page wide by 2 tall.

--
Regards,

OssieMac



"robzrob" wrote:
Hello

I've got a spreadsheet which I regularly update and email to others
for their use. *In every version, it's always set up with the 'Zero
Values' box unchecked.

When the others open the spreadsheet from their email, zero values are
showing. *Also, with one particular user (who uses the same printer as
me), the pages of her spreadsheet are longer than they should be so
hers won't print on 2 pages as it should, the bottom of each page is
'hanging over' on to the next one so she gets 4 pages.

Any clues?

Thanks
R- Hide quoted text -

- Show quoted text -

Thanks. I'll have to have a good look at that printer set-up. I've
actually cured the zero thing by setting up a macro to uncheck zero
values which runs automatically whenever the workbook is opened.