Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

Zero Values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
robzrob - 29 Mar 2008 13:56 GMT
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
OssieMac - 30 Mar 2008 00:24 GMT
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.

Signature

Regards,

OssieMac

> Hello
>
[quoted text clipped - 12 lines]
> Thanks
> R
robzrob - 30 Mar 2008 01:38 GMT
On Mar 29, 11:24 pm, OssieMac <Ossie...@discussions.microsoft.com>
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
[quoted text clipped - 25 lines]
>
> - 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.