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...Can't Synchronize my Hotmail folders
I'm using Outlook 2003 to synchronize my free Hotmail account folders.
Everything was working ok. But today, for unknown resone, I'm
receiving an error message says:
Task 'Hotmail: Folder:Inbox Downloading all items.' reported error
(0x800CCC32) : 'Access to the account was denied. Verify that your user
name and password are correct. The server responded 'Authorization
The message is received for all other folders too.
"MMSs" <firstname.lastname@example.org> wrote in message
> I...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,...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.
...replication of public folder running slowly
I got about 10GB data need to move from Server A to Server B (both running
ex2000 and same domain ) , replication running slowly ( about 100MB per
day ) .. any idea??? the replication setting is "always run" already..
is there any tool can use to copy public folder directly ??
...Do/Can Public folders synch with GAL???
I am now being told by IT that Public Folders do not synch with the Exchange
Global Address List, but are another duplicated source of contacts. And so
they will not put Public folders in place. Is this true? Or is there a way
to synchronise them?
I want to use Public folders to share company contact lists and use the
enriched functionality of Outlook, but does seem limited if they won't sync
with the GAL. The GAL is used to feed other data systems and so has to link
Any thoughts would be welcome- and thank you for responses to my previous
Ozman <email@example.com...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...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:
...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...Public Folders #10
I am attempting to set up a public file to hold my calendar information in a copy of Outlook 2002. This is running on my Windows 2003 Server with Windows Exchange Server 2003. The help file in Outlook instructs that you go to the folder list and then create a new folder and then you can copy existing .pst files into the new folder. In looking at the folders in the list I note that there are none listed as Public Folders. What have I done wrong? Any direction would be greatly appreciated
...Windows Explorer folder columns layout
Where does Windows Explorer store column layout for Details View for a
particular folder? I need to be able to set which columns are shown and their
order for a particular folder.
I know Explorer stores a lot of information in:
I'm not sure that's where it stores the view for each folder, but perhaps
starting there will lead you somewhere.
"Sasha" <Sasha@discussions.microsoft.com> wrote in message
news:46541...Email with attached email in shared mailbox
I have a user that is unable to open attached Outlook email message in a
shared mailbox more than once without closing out & reopening Outlook. She
is using Outlook 2003 SP3 (11.8206.8202) under Windows XP SP2.
The user is able to open a message and open any attached email messages
once without any problems. However, if she closes the attached email message
and attempts to reopen it, she immediately receives 'Operation Failed'. If
she copies the message with the attached messages to her main Outlook
mailbox, she can open the attached messages as many times as she wis...re re re ????
I purchased Outlook 2003 and installed it on my WIN XP
When I install the add-on personal folders backup tool
(definately 2003 version) I get an error 1304 - cannot
write to G:/PROG../MICROSO../OFFICE11/backaapl.exe
I assume it's OK to have Outlook and Office installed on
the G drive instead of the C drive. I tried changing the
read permissions to write permission for OFFICE11 - no go.
I installed the video update with no problems. Any ideas
Operating System: Microsoft Windows XP Home Edition (5.1,
Build 2600) Service Pack 1 (2600.xpsp2.030422-1633)
System Manu...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, ...clear the list og "open other users folder"
When you use the open an other user folder, it could be a
calendar, the persons name and folder is put into a list
under the menu File/Open. I would like to clear that
numbered list of folders, does anyone know how to do that?
...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: 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:220.127.116.11
> Newsgroups: microsoft.public.outlook.general
> NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 18.104.22.168
> 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: 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: 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: 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...Delegating rights to change email addresses on public folders
I saw something mentioned in a book once about delegating more rights
to a public folder tree but can't seem to find it.
What we want to do is take a branch of our public folders and provide
a local admin the ability to change email addresses (smtp). This is
really the only thing we want them to do, however.
Anyone know how to properly do this type of permissioning?
We are running Exchange 2003 SP2 in a mixed mode environment.