Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
I cannot start about 3 service on my exchange server5.5
and it gives this error when trying to start the
information store - 'The Microsoft Exchange Information
Store service returned service specific error 4294966767'
have any body experienced this and what can i do?
Please see the following article:
246272 XADM: Service Specific Error 4294966767 Appears, Information Store
Hope that helps.
Enterprise Messaging Support
This posting is provided "AS IS" with no warranties, and c...hi 03-24-10
hola como estas
“日hola como estas
...Email Customer from Dynamics GP
Here's a link to a simple VBA customization that will make the Email link
"work" on the Internet Info window. You can get to this window by clicking
on the "I" beside the Address ID field.
Microsoft GP/SBF Specialist
The email link works as is. Simply add email addresses as
Mailto:firstname.lastname@example.org and the user can then just click on
the link and their default email client will open with...SSRS and GP
It's my first time to install SSRS to use it in GP and was getting the error
in the screenshot below:
i've tried using the Mariano's instructions in the link below to no avail:
I'm using SQL Server 2008 and GP 10 SP4. any ideas what to check?
after a few tweaks, was able to get it to work.
> It's my first time to install SSRS to use it in GP and was get...attachments on Outlook Express #2
The attachments on my incoming email are shadowed out and
I can't open them. How can I get the attachments to open?
Here is a link to an article that explains how to disable the security
feature that blocks attachments,
I hope this information is helpful.
Partner Technical Lead -- Outlook/Office Setup
Microsoft Technical Support for Platforms and Business Applications
>From: "HELP PLEASE!!!!!!!!" <anonymous@discussio...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...Pivot Table #2
I have a database with type and age ranges in columns. Six age ranges. One
type column. The data (dollars), by type and age range are below each age
range column. I want a summary report that sums the dollars by type and age
combined. My preference is to have the sum of age ranges in the rows, the
type in the columns with the dollar sum of each type and age range in the
data fields. I hope to have the sum of the types for all ages on the right
and the sum of the ages for all types at the bottom. It seems simple enough
I don't seem to be able to make the table work?
If ...http virtual server error #2
We have an exchange 2003 sp2 setup on a cluster. anytime the server fails
over the IIS host headers for the http virtual server are re stamped. We
found the kb article here
This worked beautifully on one of the clusters, but the other two give me
error messages when attemping to go to the http virtual server properties via
The error is:
"Exchange System Manager"
An unexpected error occured
ID no: 8000ffff
Exchange System Manager
When you click ok, the properties do come up but the general tab is a...Dynamic xslt and transform with-out System.IO
Anyone know if there is a way to dynamicly create a Xslt template/s and use
them as an
xml transform with-out use files for the Xslt?
All the methods I see use files.
I want to create a Xslt transform via code?
Any examples would be great.
> Anyone know if there is a way to dynamicly create a Xslt template/s and use
> them as an
> xml transform with-out use files for the Xslt?
> All the methods I see use files.
> I want to create a Xslt transform via code?
Basically any XSLT stylesheet is just XML document, so of course yo...2 or more columns on a report
I have a report that has only a couple of fields that it's pulling from, so
when I print my report, there's not a lot there. It looks basically like
Employee Name Avg. Score # Completed
Doe, John 95 2
Smith, Mary 68 3
and so on. My question is this: Is there a way to put 2 groups of this info
on the report page to condense the number of pages I have to print out? I'd
like to report to look something like this:
Employee name Avg. Score # Completed Employee Name Avg. Score #
Completed ...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...If Function help #2
I have what should be a simple IF then formula, which is copied below,
where both criteria must be met: Z9 must be true and S9 must = COS.
Any assistance why this isn't working would be greatly appreciated.
What is contained in Z9?
Maybe you need
<email@example.com> wrote in message
>I have what should be a simple IF then formula, which is copied below,
> where b...Exchange Server Quota Message Service
I'm testing ExQMS.exe, file version 184.108.40.206, in our Ex2k3 environment.
Client is OLK2K3.
Has anyone worked with this ad-on for Exchange ? Are their any unknowns, or
gotchas that one should be aware of this add-on?
In one test environment I have this product working..but in another test
environment, I'm getting RPC errors and in the app event log it shows...
"Faulting Application QuotaService.exe version 6.5.7830.0 faulting module
unknown, version 0.0.0.0 fault address 0x616e346e "
Any information that can be provided would be most helpful.
How best to put th...Account Balance Wrong #2
I just opened a new investment account and put it into MS Money 2008 H&B.
The account was started on 7/10/08 and I started it with a zero balance and
confirmed that the zero balance shows in the account settings as the
starting amount. If I go to portfolio manager and look at the account the
correct balances show from 7/16/08 through today. If I look at portfolio
manager for any earlier date the amount of cash is shown incorrectly. If I
look in portfolio manager for the account and change the date to 6/15/08
(before the account even existed) it shows a large positive cash balance...GP Alert Formula
I need to create a business alert that contains only certain inventory items.
Is there a way to include items based on item number? For example, I need
to create a report that includes all inventory items that begin with "A" or
...Business Portal 2.7 and eReq (print a PO, display GL account descr
Has anybody tried diplaying the GL acct description when you choose to viiew
a doc in eReg.
Also, has anbody been able to print or display the PO that gets creaed in
eReq from the eReq module without having to log inot Great Plains to get
access to it.
...DTC Service Failing Regularly
We use the Integration for Great Plains with CRM 1.2. Recently the
Distributed Transaction Coordinator (DTC) Service on our integration server
has started failing regularly several times a day. DOes anyone have any
ideas as to what might be causing this? Once it fails it causes all the
integration's scheduled jobs to fail and extremely high LSASS activity (about
60% CPU constantly).
Any advice would be much appreciated.
...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Calendar in Excel #2
Can someone help me with a calendar to use in Excel that
can be formatted so as to show special dates, current
holidays, etc. WARNING: I need explicit instructions. This
sort of stuff is not intuitive to me.
Why not do your calendar in Outlook. Select which style you
want....day/week/month. Then go to new input important dates. Save. Print
"Dot Appleman" wrote:
> Can someone help me with a calendar to use in Excel that
> can be formatted so as to show special dates, current
> holidays, etc. WARNING: I need explicit instructions. This
> sor...2 Y axes graphing 10 yrs of daily stock data
I'm stuck. I'm trying to graph daily stock price as well as a calculation
based on daily price over about 10 years of data. When I graph one of these
columns against date, the graph looks great. When I try to graph both
columns (which need different y axes because they are different magnitudes)
against date using custom - lines on 2 axes, excel starts showing every
single date on the x axis rather than the time scale or category it was
showing before. The x axis becomes unreadable as it is painted with
thousands of dates. Help!
> I'm stuck. I'm trying to g...Exchange 2003 Permissions #2
I have a Windows 2003 Active Directory domain and a NT 4.0 domain
connected by ADC. I have user's in the NT40 domain who need to Manage
one of my 4 Exchange 2003 Servers. I have gone through the Delegation
Wizard in Exchange Manager and granted them Exchange Administrator
privledge. I do not want to make the users Domain Admins. They can
access System Manager and expand everything but the Servers. When the
click on Servers they get this error message:
There is no such object on the server.
ID no: c0072030
Exchange System Manager.
...Act -> CRM 1.2
I know just about nothing on the subject of importing act
data into CRM 1.2
Could any one help me out with a quick overview of the
I know about using export pro to get the data into access.
I think from there you simply use the data import tool
that MS provides from crm.
MAIN QUESTION: Can I import act data once CRM is up and
I really do hope so.
I'd hate to find out that we needed to create the
database 1st and then select "connect to existing
database" during the install process.
Thanks in advance!!!!
> Hi all.
> I know just...