Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
when i try to print my business card or printview it tells me3 unable to load
driver. Although printer works in all other applications
Go to the manufacture's web site of your printer model, see if there is an
Or you might re-install the driver you have, it is always wise to completely
uninstall a driver before installing/reinstalling a driver.
Bruce Sanderson's Windows Web
How to clean up printer drivers
Mary Sauer MSFT MVP
news://msnews.microsoft.co...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...Contact Ribbon
The DELETE option in the Actions box of the Contact tab is right next to the
SAVE & CLOSE option. I have allready deleted 2 of my contacts. It seams
they should have put the delete option in a safer place? I am aware that the
ribbon can not be changed. I am a new user to Office 07 and will probably
become more carfull as time goes on. Is there a way to undo delete? Is
there any other way to get the Contact back other than locating the
information and re-entering it?
Might I suggest just clicking the "x" to close and then answer "Yes" t...Prevent Copy, Print, etc.
This is a multi-part message in MIME format.
Is there some way to prevent an email in Outlook 2007 from being copied, =
forwarded, printed, etc. when sent?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DCont...How do I get a pasted screen print to appear?
I have created a screen print and pasted it into Excel. However, whenever I
close and re-open the file or simply toggle to another tab, the screen print
dissapears. The only way I can make it reappear is to select "Reset Picture"
from the "Picture Toolbar." I have tried to "Bring to Front" the picture but
that doesn't make the picture appear at all.
Does anyone know what the solution is to have this screenprint permanently
show up so that I don't have to continually press "Reset Picture"?
...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <email@example.com> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...Print Limitation?
I have a user that receives email with alot of
attachments. The user wants to print the email with a list
of attachments for distribution purposes. I currently have
Outlook set up with the ability to print an icon view of
the attachments. Is there any way to set up Outlook to
print a listing of the attachments instead of large icons.
Operating System = Windows 2000 Pro SP4
Office = 2000 Pro SP3
Thanks in advance,
...Print multiple non-sequential pages?
Having been playing around with various printing methods for the past week
or so, I'm noticing that I don't see any method to print via VBA a set of
pages in a non-sequential order...
DoCmd.PrintOut offers us a Range to work with, but how about particular page
Ex. Pages 1-4, 9, 15
Is the standard method for this to use PrintOut 3 times, one for 1-4,
another for 9, and another for 15? I don't see any reason why I couldn't do
this, but was wondering if the feature is built-in somewhere and I haven't
...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...printed product is different than on screen
Microsoft Publisher- I have formed a rectangle and set the color to be "0% transparent to 100% transparent" which creates a fade to nothing look. Well, when I print it, it is not transparent at all. It is a completely colored in rectangle. I have put it on CD and taken to Kinko's and the same thing happens. It's not the printer and probably not the program (Word does it too). Any suggestions? Please help if possible.
Fact of life when not printing to an inkjet printer.
There are various work arounds, but it depends what you have to do.
The US should free all those
ille...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...PO Printing ERROR
I am facing problum in printing the Purchase order after approval.
When i open any PO and try to print it by pressing PRINT button it shows an
"Run Time Error 13, Type Mismatch"
and Quit form RMS Manager
Plz any one help me out from this problum.
...How to "flow" a excel spreadsheet while printing
I have a long vertical excel spreadsheet. When I print it, it
occupies the left portion of the paper. I manipulate the printer
settings so that it occupies 2 columns. However, I'm not able to port
the settings across printers and I have to set it again when I
distribute the spreadsheet.
Is there a setting in Excel which allows me to flow the vertical
columns into multiple columns ? eg left, centre, right on 1 page ?
Thanks very much in advance for your advice.
As far as I know you need to split up the multi column work sheet over
several worksheets. Start by selecting t...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <firstname.lastname@example.org> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...Catalog Merge templates do not line up when printed
It appears the "next record" logic in the Publisher mail merge logic is
missing when attempting to print any document that has more than 1 copy per
sheet? Publisher will only print data from one record per physical page and
not move to next record for each postcard on the page. ie) 8.5" x 11" paper,
8.5" x 5.5" post card, 1 column per page, 2 cards per page
But has anyone, in the MVP community, created a workaround? Being a long
time user of MS tools, we always had to hack around the MS shortcomings. I'm
not a Publisher expert and need to get a fix...Cannot Print
I have OneNote 07. When I have an open document in Word and click print, it
automatically goes to OneNote, I click Print and states "Please wait while
OneNote adds a printout of the document" and I don't recieve a printed copy.
I am so frustrated! I cannot find a preference button to see why this is
My college classes have started and I cannot print anything. Will someone
please help me?
Just figured out what was wrong. Thanks
> I have OneNote 07. When I have an open document in Word and click print,...Hiding plot Area
I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2:D6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2:D6 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)
All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. ...print 2 worksheets on the same page side-by side
I am creating a template that has two worksheets, I need to print the
worksheets on the same page side-by-side. The problem I am having with them
on the same page is when I hide the rows with zero values on one side it
hides the the numbers on the other side
You have a response at your other thread.
> I am creating a template that has two worksheets, I need to print the
> worksheets on the same page side-by-side. The problem I am having with them
> on the same page is when I hide the rows with zero values on one side it
> hides the the numbers on the other s...Hiding rows with VBA
In my sheet called "insertsheet I have this VBA:
(thanks to some users of Google groups)
Private Sub Worksheet_Change(ByVal Target As Range)
Const nMAX As Long = 10
Dim nRows As Long
Application.ScreenUpdating = False
If Intersect(Target(1), .Cells) Is Nothing Then Exit
nRows = .Value
.Range(.Cells(1, 5), .Cells(1, _
.Columns.Count)).EntireColumn.Hidden = True
.Range(Cells(1, 5), .Cells(1, _
...Printing a Booklet on 8.5 X 11
Sorry, gave wrong email address before.
I am trying to print a booklet on 8.5" X 11" paper,
landscaped & folded in half (5.5" X 8.5"). The only
option I can find in MSPUB help is printing and 8.5 X 11
on 11 X 17 paper.
Anyone have suggestions??
Greetings, I would like to loop through a query printing a report based on
the current record. Any ideas?
Guessing as to what you mean, you could specify the criteria in the report's
Record Source query, or you could use the Where condition of the OpenReport
If more information is needed, you must supply more details.
>Greetings, I would like to loop through a query printing a report based on
>the current record. Any ideas?
Message posted via http://www.accessmonster.com
On Fri, 30 Apr 2010 07:03:01 -0700, Jeff wrote:
> Greetings, ...Trouble with toggleButtons on ribbon
Hi, I have two custom toggle buttons on a ribbon and my code looks okay to
me, but obviously I've done something wrong because everytime I click either
one, I get "Object variable or with block variable not set" error; my code is
below, can someone PLEASE help me out with this?
Public gRibbonUI As IRibbonUI
Public gbPressed1 As Boolean
Public gbPressed2 As Boolean
'Callback for customUI.onLoad
Sub rxRibbonUI_onLoad(ribbon As IRibbonUI)
Set gRibbonUI = ribbon
'Callback for rxTB1 getLabel
Sub BalAct_getLabel(control As IRibbonControl, ByRef retu...