Excel 2002 Pivot Report Mystery
I have created a pivot report in Excel XP and have encountered a
problem. The report is created for one field, in a columar format.
When the report is completed, the capability to filter is evident, for
both the various values in the field, and for the Data that has been
calculated in the report.
The field, Project # has 35 unique values, fron 101 to 135, and I have
calculated two Sums, two averages and one count for each of these
fields, seven rows of calculations for each project.
When the filter list is displayed for Project #, I clear the Show All
check box and select one of the projects...divide by zero error on purchase order report
On a clean install of headquarters manager I get a divide by zero error on
the standard purchase order report. Regardless of what date range I put in it
generates the same error.
Any one else had this problem?
You have a purchase order in the system with an exchange rate of zero.
Run the following SQL Statement from HQ Administrator:
Select PONumber, POTitle, StoreID, ID, ExchangeRate
where ExchangeRate = 0
This will tell you which PO is causing the error, but fixing it will be
a problem as there is really no PO Editing function in HQ.
You could use a SQL Upda...How to (if at all) show/hide taskbar programatically?
I'd like to be able to show and hide the windows task bar from within my app
(hide at begin and show when the app quits...).
Try the following
HWND hWndTaskBar = ::FindWindow( TEXT("Shell_TrayWnd"), NULL );
if ( hWndTaskBar )
::ShowWindow( hWndTaskBar, SW_HIDE /* or SW_SHOW */ );
Check Abdoul [ VC++ MVP ]
"Philipp Huber" <email@example.com> wrote in message
> I'd like to be able to show ...How to produce a chart based on number of cells not values in the cells
I'm using Excel 2007. I have a requirement to base a chart on the
number cells rather than the values in the cell.
For example, here are some values I might enter against Monday to
In this example, I want my (pie) chart to show that 3/5 are value 1,
1/5 is value 2 and 1/5 is value 3 (i.e. the pie chart should have 3
What excel does, is split the chart into 8 sections, and shows each
Any suggestions on how I might achieve this,
Thanks for any help
You need to do some calculations in the sheet first, then plot the results:
http...Item with a negative serial number count
We just did a stock count in Geat Plains. We had a problem with one of our
items. The item had a negative serial number count of two. I ended up
deleting the item off of the count so I could process the stock count. How
can I fix this item's serial number count to zero so it won't cause a problem
next time we do a stock count?
You need to analyze the transactions on that item to determine why
it's showing negative. Theoretically, that shouldn't happen because
you shouldn't be able to consume the same serial number more than
The analysis may help...How do I use numbered bullets in Excel?
Is that possible to use numbered bullets inside cells in Excel? If so, how?
If you just have one bullet point in a cell you could make a custom format of
bullet point character followed by # (copy the bullet symbol from the
Character Map available under Windows Accessories) and apply this to your
cells to make them look like bullets. If you want a proper bulleted list it
would probably be better to use Insert->Object and bring in a Microsoft Word
Document object where you could create a bulleted list more easily.
http://www.strat...Want to link a cell of numbers with a cell of text & can sort
I have a column of #s and a column of text. The column of text describes
the column of numbers. I don't want to have to retype either column. Is it
possible to LINK/CONNECT the two columns so that they will act as one unitl?
If I try to merge the cells in the same row of the two different columns I
lose the text.
This is important because I must monthly import data and the data in the
columns could either increase or decrease.
you might consider a formula.
if you need a space between the numbers and text....
=A2&&qu...Excel Newbie-Simple Question Regarding Numbers Formats
Trying to enter positive numbers (no decimal places)
into cells that start with the number zero.No luck.
Tried "Help"...couldn't figure it out (after 30 minutes).
Can somebody walk me through it? I'm using Excel 2000.
The only way I know a number starting with zero (0) can be entered in
cell without losing the 0 is to put an apostrophe before entering th
and this will register in the cell as 012345. But then, technically
this is not in a number format. This will be a text.
BTW, how can a number starting with 0 not have a decimal place i...Report problems when upgrading
I have not upgraded from Money 98 because of a
continual problem I have had with reports in each newer
Money version. When I auto convert, or manually enter
transactions, all transactions show up on the Performance
by Investment Account report as being in the current year,
no matter what the date is. For example, say I enter a
purchase of $25,000 on 1/1/2000. If I look at a
Performance by Investment Account for 1/1/2003 -
12/31/2003, I will see $25,000 in the "Buys" column. If
if I click on it, there will be no transactions for the
date range (because it was in 2000). ...Money 05 can't add numbers
The identical accounts and balances shown in the portfolio selection and
then on the home investing page of money do no add to hte same figure. The
Investing page is incorrect. Anyone been able to teach Money 05 how to add a
column of numbers?
...Error when trying to create reports
I am getting an error: There has been an error reading
or writing the file '.'
Anyone know how to fix this?
In microsoft.public.money, Peggy wrote:
>I am getting an error: There has been an error reading
>or writing the file '.'
>Anyone know how to fix this?
See if any of these resembles your situation:
Thank you, Cal!!...Number formatting question
I have hundreds of rows of numbers (example 234553) it need to add a decimal
to every row to make it 2345.53. Is this possible?
Put the value 100 in a blank cell.
With that cell selected, Edit/Copy
Select the numbers you wish to change (highlight the column)
Use Edit/Paste Special and select the Divide option.
"sbhayes" <firstname.lastname@example.org> wrote in message
> I have hundreds of rows of numbers (example 234553) it need to add a
> to every row to make it 2345.5...Chrystal reports and using custom fields as a filter
I’ve read a comment on the problem that occurs when using custom fields as a
filter for Chrystal Reports in MS CRM.
This is the related post on the MS CRM newsgroup.
or open the report and click Database - verify database to make the report
aware of the new fields
Microsoft CRM MVP
"Stephen Redmond" <email@example.com> wrote in message
>You need to refresh the report...Copying FRx reports company to new machine
Just re-installed mas90/FRx on a new machine, but can't figure out how
to bring over my company, named VSI. Where are the files, or how do I
tell where it's located in order to hook in all the work I've done to
the new installation of FRx???
First, you should have just cut out the part about MAS 90. Yuk. :)
Do you still have access to the old machine? Without being able to log into
FRx from an existing machine, it's going to be difficult to determine where
the files were/are located.
Do you know if the files were installed on the c drive of the old machine or
on the net...XADM: Error 1084 Reports corruption in an RTF Attachment
Just got this error message on my Exchange 2000 enterprise server for the
MSExchange IS Mailbox store in the event logs. The server is running OK.
The store is working OK. Checked article 232685 and it said that exchange is
operating by design but the article is refering to Exch 5.5
Is this error safe to ignore. No third party products have been installed
in the last year.
...Unwanted MsgBox shows in error
I used to have a MsgBox at the end of my code and recently changed it to
display a different message. However, every time I run the macro, the
original message is displayed at the end. Where is it coming from? Thank you.
I would think it is coming from a MessageBox that you have somewhere in your
code. If the message is a text constant, try doing a project-wise search for
that text to see if you can locate it.
Rick (MVP - Excel)
"Tony7659" <Tony7659@discussions.microsoft.com> wrote in message
news:1B25695B-88D4-43E4-A573-0A16415E1654@microsoft.c...How do I only show print area in excel?
I cant figure out how to only show the printable area in excel, and have all
other cells greyed out? Can anybody help.
View - Page Break Preview will sort of do that, though you can still see the
cells that are outside the print area. I think a macro could make it
totally invisible, if you want to go that route. We can write you one.
mvpearl omitthisword at verizon period net
"Jeffro" <Jeffro@discussions.microsoft.com> wrote in message
>...Possible to show stock price next to its option?
Money 2005 Premium does a reasonably good job of handling equity options
(biggest problem: doesn't exercise written puts properly). It would be very
handy to see in a portfolio or report the stock price of the underlying
security for an option.
For example, if I sell a $25 June 05 Microsoft Put, I can see lots of
information about that option in reports and the portfolio screen. However,
I don't see the choice of seeing the underlying stock price - Microsoft's
stock price - next to the option. This would be really handy to know how far
the option is in/at/out of the mone...detailed sales report -- Total costs and Total profits
When we run detailed sales report and group by product, it appears the cost
column displays the unit cost per item and the profit column displays the
profit per item, but not total costs (cost times quantity) and total profit
(profit times quantity).
For example, a row of data reads
qty sold sold price total sales cost profit
2 2.5 5 .59 1.91
If I sold 2 items which cost .59 each, that's $1.18 of total cost against
$5.00 of sales, leading to $3.82 total profit.
Is there a report that will give m...dividing a number into hours and minutes
My users are entering numbers into column B. Is it possible to take the
total of column B (say Row X) and divide it into hours and minutes putting
the hours in Row X Column D and minuntes in Row X Column E (two seperate
cells)? They are entering just numbers in multiples of 5 and usually not
more than 30 minutes. Do I need to convert Column B to some form of 'time'
to get close to the result I'm looking for? Is this even doable?
In D1, enter =INT(B1/60)
In E1, enter =MOD(B1,60)
In this example, Row X is row 1.
Hope this helps,
&...How can you identify folders, using folder numbers?
I've searched and searched and asked in the quasi-defunct yahoo
exchange newsgroup, but I've never found an answer as to how I can
actually utilize the folder identification information contained in
Exchange error log events.
An example is as such:
Source: MSExchangeIS Mailbox Store
Description: Error 0x6bb deleting unused restricted view from folder
1-1A42FF on database "First Storage Group\SG1 Mailbox1".
It would be insanely useful if I could tell which folder 1-1A42FF is,
so I can narrow down where the problem is occurring, you know??
Anyone...report not grouping correctly
i set up a report with grouping on Repair, Employee. My Employee isnt
grouping right. Say the employee name is Stephen, it will group half of
everything with Stephen, then another half with Stephen... I have looked at
the form to make sure it is entered correctly and it is.. I cant figure it
Message posted via http://www.accessmonster.com
I do not understand. It seems like it is grouping like it is suppose to as
is not the same as
and would be another group.
Am I missing something or reading what you wrote incorrectly?
Try ...Cancelled transaction report
I'm looking for a report of cancelled/aborted transactions
Any help would be appreciated!
...BACS reports and listings and comment box
Please could we have the BACS status report and the comment box back on the
Print cheques function?
The BACS status report was used by many clients as a verification and
printed for signature of confirmation that the BACS file was accurate and
approved. As there is no other approval on this process and the text file is
not encrypted in any way this provided a useful back-up.
The comments box on the Cheque Printing window was used to enter a comment
referring to when the payment would clear the payees bank account. There is
now no feature for being able to include this text as part of...generating random number as template
I need to create a form in excel that generates a unique number for each
form. If anyone can assist with the best way to do this it would be great.
Explain what you mean please.
> I need to create a form in excel that generates a unique number for each
> form. If anyone can assist with the best way to do this it would be great.
What you need is a Forms collection object, but in Excel that will only work
for already loaded forms.
So first create the collection yourself, and then browse through it.
Dim i, u As Long, s ...