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
...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,...Money 2004 Small Business
Question-- Will Money 2004 Small business support
Schedule F (Farm) expenses?
...Query not found in Dataviewer Business Portal 3.0
I am new to BP...and working my way through it.
I was in the INVENTORY section and was modifying the queries to show all
rows and no "Pick a Task" section.
When I clicked "apply" I was returned with "One or more errors have
occurred....Can not change Web Part Title due to a save error on the foler.
/DataViewer/Item List-Item List".
NOW I cannot get ITEMS>view Inventory Information to work. Dataviewer shows
a folder marked Item List-Item List/Item List but the whole thing doesn't
appear to work.
I need to help in fixing.
Thanks ...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.
...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.
...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...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...Microsoft Money 2004 Sm Business Won't Open
I have Microsoft Money 2004 Small Business edition and
have installed it a bunch of times trying to work out a
problem. The program still installs but when I try to open
it I get an error message that says 'Money has encountered
a problem and needs to close. Sorry for the
inconvienience". The program then closes. Does anyone know
how to fix this problem?
3. Delete money directory from program files.
4. Delete Money entries from the registry.
5. Reboot again.
"Gaylon" <email@example.com...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...Outlook Business Contact Manger History Errors
I'm running the 120 day trial version of Outlook 2003 with
Business Contact Manager. All of a sudden, when I open up
a contact in Business Contact manager, under the history
tab I see all the emails in my inbox. When I click 'Add'
on Business Contact History, it does nothing. I've
changed no parameters and this was not showing before.
The only change I made was to download a critical update
for Office 2003. Anyone else seen this problem?
I do NOT have outlook setup to automatically log email as
...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...Free/Busy Issues
Hi all. Our Exchange server is Exchange 2003 running on Windows 2003 Server.
The client machine in question is running Windows 2000, SP3, and Outlook XP
(10). The problem I'm having is that his Outlook client isn't publishing his
Free/Busy information to Exchange, despite the setting being set for 6
months worth of data. I've ran Windows update and Office update, uninstalled
Office, ran RegClean, and reinstalled office, all to no avail. I know it's
Outlook, and not Exchange, because an article on the net suggested deleting
the user specific Free/Busy entry on the exchange serve...Business Contact Manager #34
I recently had installed Business Contact Manager onto
Outlook 2003. Then my PC crashed. The only file we saved
was the PST.
My question: have I lost all contacts that I
had "converted" into ACCOUNTS in BCM?
It appears that way...but just wondering if maybe I am
missing something obvious.
I have all my contact info EXCEPT my key customers.....
Any help is appreciated
...re re re ????
...Re-enter payee information
I have been using MS Money to pay bills and frequent
annoyance is when I type in the payee, the selection list
never shows the payees. I type it in and have to re-
enter the account number and everything. Doesn't make
sense that i have to keep putting this in. Anyone know
what I am doing wrong? I've checked these boards and
found help with my passport problem but no entries on
Money has two kinds of Payees. Explicit--those on the explicit list that
shows in Accounts & Bills|Categories & Payees|Payees--and implicit--those
that are recorded somewhere in a tra...Re: Where should be the best place to stored Applcation Data Files?
"Giovanni Dicanio" <gdicanio@_NOSPAM_email_DOT_it> ha scritto nel messaggio
> BTW: this post by John Robbins is very interesting reading:
copy-and-pasto - the correct link is this:
And then there's this Vista security discussion from last Friday (cool
On Fri, 8 Aug 2008 18:50:23 +0200, ...Re: Outlook locks up with a officelifeboathang
"Andy Lay" <firstname.lastname@example.org> wrote in message news:...
> Message-ID: <email@example.com>
> X-Mailer: http://www.umailcampaign.com, ip log:22.214.171.124
> Newsgroups: microsoft.public.outlook.general
> NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 126.96.36.199
> Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl!newspe.com
> Lines: 1
> Xref: TK2MSFTNGP01.phx.gbl microsoft.public.outlook.general:737044
> Hi Swinglower-
> I have luck as you do :) A Chief Exec machine with this very issue....RE: Apply this critical update from M$
Content-Type: multipart/related; boundary="axyeonzy";
Content-Type: multipart/alternative; boundary="innmlsikefhcqjc"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to continue keep...Re: Share sub-folder in Inbox
I already grant the permission to right person and add secondary mailbox to
the exchange account, in his outlook folder list, he can see the shared
mailbox, but only mailbox not the sub-folder, if we share those sub-folders
individually, then we can view under shared mailbox, but this shouldn't be
the way. we want it sub-folder can be viewed and not be set one by one.
"Sue Mosher [MVP-Outlook]" <firstname.lastname@example.org> wrote in message
Either you haven't completed the process of granting permission...Re: How to delay ToolTip display time in CListCtrl Control
"Smallfrogs" <email@example.com> д���ʼ� news:...
> "Ali R." <firstname.lastname@example.org> д���ʼ�
> > ((CListCtrl
> > or if you have variable for your list
> > m_MyList.GetToolTips()->SetDelayTime(TTDT_AUTOPOP,5000);
> > that will set how long it stays up after it is displayed.
> > Change TTDT_AUTOPOP with TTDT_INITIAL to change the...RE RE: XP Install
Thank you for the information.
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
Dilly Dally wrote:
> Thank you for the information.
Did you post a whole new conversation to 'reply' to one you started?
It certainly looks like it right now:
That is your original posting - as archived. As of right now (could be I
need to wait for it ...printing different business cards on the same sheet
How do I print the same business cards, but with
different peoples name on them. Say there is ten cards to
a sheet and I want to print five with my name and 5 with
one of my employees name on them. I have done all kinds
of searches and can't figure out how to do this. Please
MVP Microsoft [Publisher]
"Brian McCoy" <email@example.com> wrote in message
> How do I print the same business cards, but with
> different peoples name on them. Say there is ten cards to
> a s...