Using pivot table without summing, etc. #3
Of course! I don't know how that slipped me by.
Peter Bernadyne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=701
View this thread: http://www.excelforum.com/showthread.php?threadid=26649
...analytical accounting lookups should only show valid codes
When entering AA transaction distributions, the code lookup window should
only show valid code combinations. It's not intuitive for the user to have
to select a code and get an error message to discover which codes are valid.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the mess...Pivot Table Reversing
I have a Pivot Table that someone has created for me, which lists some data
chronologically by month which has the earliest months at the left, and
latest at the right.
Is there any way I can reverse the order so that the latest data is at the
I am fairly Excel conversant, although I have never dablled with Pivot
Tables before, also, I know some VBA so a solution along those lines wouldn't
bother me either.
You could try a descending sort on the pivot table field concerned.
"Neil" <Neil@discussions.microsoft.com> wrote in message
news:C01E2FB1-6B0C-41E1-BC2E...How to recover data from OL2003 OST file when Exchange Server is no longer available
After Exchange Server (in Windows Small Business Server 2003) is no longer
available, I still have an OST file (created in OL 2003), just under 2 GB in
size. Can one recover the data from this OST file?
Yes, you can get the data out of it. Do you still have the exchange profile
or very recently deleted it? if so, it's a matter of moving the stuff to a
pst. If not, you need a tool - see
http://www.slipstick.com/problems/repair2gbpst.asp for tools that you can
Diane Poremsky [MVP - Outlook]
O...i WOULD LIKE TO FREEZE OLD DATA ON GRAPH TO ALLOW FOR UPDATE VIA M
I have a excel spreadsheet which upon me running the macro updates my graphs
unfortunely due to limitations of 65,000 the system is no longer updating. I
though if I could freeze the data on the graph I could omit the old data and
just update based on the new. Any suggestions..
Excel only allows a certain number of data points on a chart, and I believe
that limit is still in place in 2007:
Data points in a data series for 2-D charts 32,000
Data points in a data series for 3-D charts 4,000
Data points for all data series in one chart 256,000
Depending on exactly what you are doi...Outlook shows offline during dial up
Having a problem with outlook 2002. Over the WAN
everything works fine. Dial up and connect to the
network (VPN) internet work fine. Outlook will sync up
however, a red x shows up in the bottom right hand
corner. Outlook shows offline, I can send and receive
but must hit send and receive. I have reloaded the
computer from scratch and still have the same problem.
Could it be a Excange setting? Any Ideas?
Thanks for the help,
If you hit File | Connect to Exchange Server what happens?
Ben M. Schorr, OneNote-MVP
**I apologize ...Show a blank result in a cell when there is no value in the "Lookup" cell
I apologize if this question has been asked, but I have been unable to find
an answer searching the topics.
I'm using the following formula in cell C3:
When I type in an employee ID in A3, his/her last name shows in C3.
However, when there is no value in A3, C3 shows error "#N/A".
Is there a way to show a blank cell in C3 until a value is entered into A3?
Thanks in advance!
On Aug 5, 10:45 am, "Michael Slater" <mslater...@comcast.net> wrote:
> I'm using the following formula in cell C3:
> =INDEX(LastNam...Show Window
I am currently developing a MFC SDI application. I want to integrate a
tray icon with it. When the application is minimized it hides by
ShowWindow(SW_HIDE) and then when double clicked on tray icon shown by
But the problem is if some other application is activated after my
application is minimized, ShowWindow shows it but it's behind some
screen. I have tried with SetFocus didn't work.
Please help me to solve this problem.
In addition to Ajay's idea you can also use SetFor...Information Stores show dismounted yet mail is still flowing...
Windows AD Mixed moded. Exchange 2003 installed on to a 2 node Microsoft
cluster. 1 Front End server...connecting to the primary cluster node.
Windows 2003 Standard on, FE Windows 2003 Enterprise Server on BEs
(<---cluster) no service packs on either. Exchange has SP1 installed on both
nodes and the FE. There are still Exchange 5.5 servers in the environment
although they are not being used.
.....the information stores and public folders all show that they are
dismounted...yet email is still flowing into and out of the server without
any issues. I just...Word Table to Access
Hi, I was wondering if expert can give me some lite to convert my word table
into access database.
Note: within each cell of my word table(s), some has multi-line data in it.
In addition, there is one row containing picture(s) as well.
So far, what I did is doing it manually for each word docs I have.
Convert Table to Text(I use ^ character for delimiter)
Save it to a text file(with char substitution, and CR/LF)
Then, Load them to Access DB.
Is there an easier way to do this?
I'd love to see it done easily in windows. What you can do is to save your
word doc to text wi...reminder still shows up
when I run Outlook.exe /cleanreminders it simply opens Outlook, I am running
"Toppro" <Toppro@discussions.microsoft.com> wrote in message
> when I run Outlook.exe /cleanreminders it simply opens Outlook, I am
Outlook version? The Windows version isn't as important and that of Outlook.
Brian Tillman [MVP-Outlook]
...getting more columns and data onto one page in Crystal
Since you can only place so much data onto a "piece of paper", likely the
answer is "no".
But, even after choosing "Landscape" in Crytal (10.0), there's not a way of
getting as many columns of data onto a report as I want--is there? Ideally,
I'd like to get 14 columns on there but am running out of room on the right.
Also, I have placed a cross-tab on my report that prints on multiple pages
instead of just one. Of course, since the cross-tab has 83 rows of data, my
guess is that there is nothing that I can do about this either. Is there?
...Using ajax call to fetch multiple results from multiple queries and showing them 1 by 1 as the results comes.
I've 20 labels in a 2x10 table on a page. for each label, data comes by
individual queries. (total 20 queries for the page.) and it takes about
30-40 seconds for the page to load, and it's not comfortable for the user to
see blank page. I want that each cell will show loading.gif images. As and
when data comes from query, the images should go visible=false, and the
label should display the values one by one. How do I do this task using
Some ASP.NET code example will be helpful for me, as I'm a kind of beginner.
...Results show as a minus. WHY?
I have an application that was developed by another developer using VB.net
which reside in a SQL table. I need to use some of the data from this table,
however the data shows as -0.5 or - 0.99 or -1.70 etc in my Access tables.
How can I get those numbers to show as a percentage with only one decimal
point to the left? Example: 3.6% or 31.4 %. Any help would be greatly
appreciated. No matter what I do it shows that dang "-" at the beginning.
You can use the Abs function to strip off the negative
And you can format that as percentage either using th...Need sum in pivot table, not count
I have a spreadsheet which I'm trying to show the sum of each item, but the
pivot table wizard only gives me a count. It will do a sum for each column
or row, but not each item. I can do this in a snap if I import the
spreadsheet into access and run a crosstab query, but the folks that are
going to be using this cant use access. here's a sample of my data:
Item Amount Month
A02214 0 JANUARY
A056480015 0 JANUARY
A13 -348 JANUARY
A16EPG-AD -2000 JANUARY
A18 -1950 JANUARY
A14RS ...Linking Sharepoint data to Visio
I am looking into the Database possibilities of Visio Professional 2007.
I managed to connect Sharepoint to Visio, but only in one way. So Sharepoint
is leading and Visio follows. Is there a way to make the connection two
ways, so that is Visio is changed, Shairepoint will follow ?
I'm going to assume that you have linked data to sharepoint via
datarecordsets. Data recordsets can roundtrip information but it has to be
done with custom code. Data recordsets can be read/updated in the document
using xml. The export then has to be coded based upon the target yo...show comments when cell is highlighted Vs when cursor runs over? #2
How do you make the comments appear when the cell is highlighted opposed to
when the mouse cursor runs over the cell?
You can press Shift/F2, or Insert/Edit Comment. If you wanted to see it
"automatically", when you select the cell, you'd need a macro, but I don't
think this is what you're asking.
> How do you make the comments appear when the cell is highlighted opposed to
> when the mouse cursor runs over the cell?
To at least Excel 2000, if you have the Tools, Options, Comment Indicator Only
you will see the co...Is it mandatory to create a recovery farm for Item Level Recovery
We want to test Item Lever Recovery in Share Point.We have successfully did
the backup but when we tried to restore test word file we are not able to
select the original server as it is not in list.
Is it mandatory to setup other server for RECOVERY FARM .
After recovering individual item do we need to manyally copy file to
original sharepoint server.
For SharePoint 2010 with DPM 2010, recovery is possible without
recovery farm creation as well. But for older versions of SharePoint and/or
with DPM 2007 recovery farm creation is required.
Praveen...Laptop Client Synchronisation
Hoping somebody can shed some light on this. When I click the Go
Offline button on my laptop to synchronise the CRM data it's get's to
Synchronising 56 Letters to offline database
and shows the following error:
Failed move data for entity 'Letter' during action saDelete,
countRows=56. Contact your system blah blah blah.
I have deleted the campaign the letters were part of (this is a
relatively new installation that I'm now starting to use) and all
traces of the letters that I can see, but no joy. I even deactivated
any entries with the 'Letter...ListView_SubItemHitTest redraws items
I have created my own CListCtrl derived control. In this I need to
override OnToolHitTest(). In this a call ListView_SubItemHitTest() to
detect over which item the mouse pointer is. But when I do that the
item is redrawn, which make my list flickering. This only happens when
I have a manifest file and when the application is dialog based and
the application run on WinXP. The following code illustrates the
CFlickerList is derived from CListCtrl:
void CFlickerList::OnCustomDraw(NMHDR* pNMHDR, LRESULT* pResult)
NMLVCUSTOMDRAW* pLVCD = reinterpret_cast<NMLVCUSTOMDRAW*>( pNM...Creating scientific data collection form
Is access right for me?
I am a natural resource and environment management specialist and I would
like to create a data collection sheet for an ecological survey. I have used
access in the past for data management, however, I am still a beginner. I
understand that I can use access to create forms that can be used to collect
and enter data. But I am not sure how to do this as it has been a while since
I have used access. Are there tutorials available for this?
I wish to collect scientific data on a number of ecological characteristics.
Are there examples of forms that have been...how to query a dataset with xml tables inside.
This is a multi-part message in MIME format.
I have two xml docs, authors & articles. Both have authorID as a common =
<?xml version=3D"1.0" encoding=3D"utf-8"?>
<!--This is a comment-->
<AuthorI...how to show numbers that begin with 0 in excel
I need to type numbers into an excel spreadsheet some of them begin with a
zero some do not. How can I have excel show the 0 in the numbers that begin
with 0. If I type 0236547 the number shows as 236547. I don't want all the
numbers I type to begin with zero.
I am using Excel 2003. Thanks very much for your help.
use a custom format with how ever many digits you need, 000000
"Dee" <Dee@discussions.microsoft.com> wrote in message
>...Comments not showing
When a SharePoint workflow is edited and a comment is added. The comment does
not display in the workflow status screen under workflow history.
It shows as follows: Task assigned to Andre Wessels was completed by System
Instead of: Task assigned to Andre Wessels was completed by System Account.
Comments: Please update to the new company logo.
This happens for all standard SharePoint workflows (Approval, Collect
Feedback). Any custom workflows does show the comment. The comment field is
update in the task item. It just does not show.
There is no error in t...Report Server shows 'Service Unavailable'
before install, the SRS setup, send me a warning, some like "the Windows
Sharepoint Services are install and not permit initialize a Reportserver
i skip wiht the installation, so..
I can't run
http://<localhost>/Reports and http://<localhost>ReportServer
show a message "Service Unavailabe", but the ReportServer service is running
How initialize that or what do i do?
> before install, the SRS set...