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...Accessing another user's calendar OL2000/OL2003/Ex2000
Here's the situation:
Running Exchange2000, v 6.0, sp4. Users are on XP/OL2003 or NT/OL2000.
(we're in the process of upgrading all of the workstations to XP.)
VIP user is on XP/OL2003. He can access his calendar just fine on his
His secretary and other office admin type people are still on NT/OL2000.
They have reviewer or editor rights to his calendar. They try to access his
calendar by chosing File/Open/Other User's Folder... and put in his name and
calendar. When they do this, the process hangs. In Task Manager, Outlook
is "Running." End the Outloo...Sql Server 2005. Best configuration and parameters.
We have a website (.NET 2.0 on IIS 6.0) and a Sql Server 2005 (9.0.4035)
running on the same machine, a Windows Server 2003 R2 Service Pack 2 with 8
GB RAM (Xeon E5405 2 Ghz). The website works with stored procedures. And max
20 users at the same time.
We are wondering the best following parameters for this particular
configuration... So, we have 2 questions:
Firstable, what is the best configuration for the 8 processors (0 --> 7) for
the processor affinity and the I/O affinity ?
Today we have:
Id Proc Proc Affinity I/O Afiinity
0 1 ...Inserting new rows into sheet
I am using the following code to insert a new row onto
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
This code will insert a new row above the current row number 5, which
is okay. My problem is that the new row has the same height and possibly
dimensions and formatting of row 4.
Can I basically tell Excel to insert a row of cells that are a default size
a size of my specification?? I dont want Excel to insert a row of cells
are the same dimensions of the above or below row. I realize that I co...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
...OLE Server Error
I receive a OLE Server error when I try to put a Word
document into my publisher document. I am using
Publisher97 and Word 2000. I have also tried using
Publisher9y and Word97 and get the same thing.
If anyone can help, I'd appreciate it.
Go to the website www.microsoft.com/data and download and install the latest
version of the MDAC Components for your operating system.
Hi Cathy (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| I receive a OLE Server error when I try to put a Word
|| document into my publisher document....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,...Problems setting up SSL on Exchange 2003 Front End server
I've had a 2-node 2003 cluster running for a while now. I'm just in the
process of setting up a FE server for this. I've installed it and got it
running, and all looks ok, but now I've come to setting up SSL I'm running
I have installed a an Enterprise Root CA on a server in the forest root. The
Exchange servers are all running in the sub-domain of this. I've followed
the instructions found on this website: http://tinyurl.com/4xa74
All seems to go well up until step 14 of the section called "Creating the
Certificate Request". I get ...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...Ex5.5 to EX2003 migrate what to do with MS mail connector/Connector for cc:Mail
I'm trying to remove the old Ex 5.5 server but some things are not clear to
-Created an Internet mail SMTP connector at the new Ex2003 server and
deleted the old Ex5.5 Internet mail connector (in/outbound mail flow works
great). But what should be done with the MS mail connector/Connector for
cc:Mail, can it be deleted and recreated at the new Ex2003 server?
-Moved all USER mail boxes and rehomed public/system folders successful to
the new EX2003 server, but should I move the "Microsoft Exchange server
mailbox manager for (servername)", "Microsoft Schedule...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.
...Move .PST File to server
I was trying an expiriment- I wanted to see if I could move my PST
File to my server so that it is backed up on the tape drive.
I copied my PST to a folder on the server then I changed the location
of the PST file and pointed it at the folder. After I did this I had
a second Personal Folder in my Outlook. This is were all of the items
were located that were in the PST file on the server.
Then I tried to get rid of the second Personal folder and go back to
the PST file on my computer. I could not delete either of the
There has to be a way to do this. Can someone tell m...Exchange Server Quota Message Service
I'm testing ExQMS.exe, file version 188.8.131.52, 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...I need a macro to find cut and paste data to new cell
I have data that I have exported to excel that I need to reformat to be able
to create a pivot table to check for duplicate entries.
On importing the data which is in the form of journal entries the memo line
is stting above the journal numbers in column D. I need to find all of the
comments and cut and paste them to column C. The comments are not all the
same but do contain the same word "To" in the comment. The journals are not
all the same size and so the comment line does not appear at regular
intervals. Any help appreciated as I am very new to VBA
...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...Second Exchange Server #3
I installed a second exchange server (both areExchange 2003) in my
organization, but some strange things happened after the installation.
Before I installed the second exchange, I have some Block List Service set
up in the Connection Filtering in Message Delivery Propertiies, and that
seemed worked fine for my exchange server, but out of a sudden I start
getting a lot of junk mails.
Also, I specified in the Defaults in the Message Delivery Properties the
size of Sending Message Size as 10m, but right now message get kicked by if
it is over 5M.
In conclusion, that message Deliver...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:
...Enabling SSL and FBA on Front End Server Issue
I currently have Exchange 2003 with a front end/ back end scenario. I
am attempting to enable Forms Based Authentication on the FE server
for security and asthetic reasons (and my boss told me to). I have
gone through many MS KB articles and used Petri.co.il as resources,
but it seens whatever I do, it does not work. I have gone through all
of the obvious steps in regard to enabling SSL, etc. I attempted to
use a THWATE cert. that we have w/o success. I created an internal
cert. and that does not work either. When I enable SSL the site
states that it is an SSL site and to add http...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...re re re ????
...WHY CAN I RECEIVE BUT NOT SEND IN OUTLOOK 2003 FROM A NEW DELL COMPUTER? pLEASE HELP
i USE AN OPTIPLEX 210, WITH VERIZON DSL AND MICROSOFT SMALL BUSINESS
EDITION 2003, WITH OUTLOOK 2003. Norton Internet Security SUite, with
DSL is not the problem I don't think. I can send out via an alternate
gmail pop account and in Outlook Express.
This doesn't happen every day, and usually when it does after 3-5 hours
of use of my computer.
I can still receive, but the SENT email gets stuck in my outbox.
I have to shut down my computer and start it up again and then I can
I had some memory problems indicated at shutdown, but no code that is
...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-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...