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've been using Money 2002 since - well - 2002. I have NEVER assigned a
password and never been asked for one. Following a complete reload of my
PC and re-install of Money when I try and open my MNY file I get asked
for a password. But I've never used a password.
Anyone got any advice or is it doomed?
Any help much appreciated.
1) you need to open the sample file and do an Internet Update then try to
open your data file.
2) This might not be the case, but it happens:
"andy staines" <email@example.com&g...Problems with Office apps after archive and install
I had to do an archive and install (without preserving users and
network settings) on my G4 (OS 10.2.8), and ever since, I've been
unable to get several Office apps to work correctly.
In Word, I get an error about not being able to open the Visual Basic
Editor, and the custom dictionary being unavailable. In Entourage, I
"do not have write access to the application folder." In Excel,
there's an error accessing the system registry.
I've tried moving things from my previous system folder back into the
current system folder, but it only seems to have made things worse.
A...Defragmenting information store on Exchange 2000
This is a multi-part message in MIME format.
Since this is the first time for me doing defragmentation, have a few =
questions if you're so kind ...
Our company Exchange 2000 Server is running out of disk space. The =
priv.stm is 6 GB and priv.edb is 4 GB size.=20
Free space on drive is 4 GB. Is that enough to run eseutil to defragment =
the database? Are there any 'tricks' that I must be aware of ? And =
approximately how lo...management reporter installation
Has anyone installed management report yet? Do both application service and
process service have to be installed or are they optional? Thanks, Janey
...XP Pro SP3
In a bit of a bind; hoping someone can help me!
I have a laptop here that was not logging in correctly - it would log in
and immediately log out. Drive showed minor failure, so I did a surface
scan and remapped the failing sector. Ran SFC which replaced one file -
still wasn't working.
So I tried a repair install. Normally, this fixes just about any darn
Not this time. On the initial boot afterwards (the black screen with
logo), it just hangs. Power down and reboot, it allows log in, then says
"windows must be activated before you can log in"...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.
...How do i change my file from a 2003 office doument to a 2000 docu.
i have done this before with a word document but i dont seem to be able to
figure out how to do it with a publisher document.... can anybody help??
File, save as, files of type, expand the menu to Publisher 2000.
Mary Sauer MS MVP
"me" <firstname.lastname@example.org> wrote in message
>i have done this before with a word document but i dont seem to be able to
> figure out how to do it with a publisher document.... can anybody he...Outlook 2000 or XP on Exchange 2003 SBS
it appears that the only way Outlook XP and 2000 users can receive their
emails is when they highlight an email already in their inbox. For instance,
if they are in their Word program and they look into their Outlook, without
highlighting an email on their inbox, it would show that they have not
receive any emails. However, the moment they highlight an email in their
inbox, then they'll receive about 5 emails that appears to have been in some
type of queue. It's obvious that they were in there for quite a while
because of the time that they were sent.
Are these client run...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...SBS CRM install then move Exchange.
Quick question hopefully.
Just wondering if anyone can clarify what I believe is possible but not 100%
sure. CRM SBS edition installed on a SBS box, can a new Exchange box is
implemented into the same domain and keep e-mail functionality of CRM?? If
it is possible and Exchange is moved off the SBS box and onto a new server,
what needs to be done to ensure it works correctly? Change registy settings
to point to new mail server? have looked and can't seem to locate them...
I have done the following:
-Run Rule Wizard and remove rules from mailboxes (sbs box)
-Un-installed th...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...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 2000 won't remember password #2
I had to reinstall office onto an XP machine, and Outlook 2000 won't
remember the account password. Yes... I have checked the box that says
"remember password." Any ideas? Is this a known problem? Any fixes?
Pete <Pete@nospam.com> wrote:
> I had to reinstall office onto an XP machine, and Outlook 2000 won't
> remember the account password. Yes... I have checked the box that says
> "remember password." Any ideas? Is this a known problem? Any fixes?
<http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&1033comm=1&spid=2557&...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...Transfer files from money 99 to money 2003
We have a new computer with money 2003, old computer has
our records in money 99. We tried to import export but
the records to not come across correctly. What should we
You shouldn't have to export or import. Just move across your .MNY data file
and open it with the newer version. See http://umpmfaq.info/faqdb.php?q=68.
"Michelle" <firstname.lastname@example.org> wrote in message
> We have a new computer with money 2003, old computer has
> our records in money 99. We tried to import export but
> the...Money '02 shuts down when I go to reports
I have been having a problem with money having to unexpectantly shut down
when I go to the reports gallery, open investments and then "performance by
investment account". It only seems to be doing this with this particular
report and started after I updated prices online. I have already tried to
reinstall with no success? I am running XP home. Any suggestions?
I dont see an error report. Only an option to send the report to Microsoft
which I have done several times. It says that MS money has encountered a
problem and needs to shut down.
I checked tehough the updated pri...Exchange 2003 stops after installing SP1
Two weeks agoe I installed SP1 om Exchange 2003 (running om Win2003
Since the installation it has frozen 4 times.
There are no events, no pre warnings, it just stops sending and
recieving mails, no reaction on mouse and keyboard. Screen is frozen
or just blue.
Any idea would be welcome.
Any time the whole box hangs solid, you usually have a bigger problem than
Exchange. Having applied SP1 may just be a coincidence.
Make sure you are running the latest device driver updates, firmware
updates, etc. for all of your hardware. Run full hardware diagnostics on
the serve...re re re ????
...converting quicken 04 to money 03
Hi, I just got money o3 with my new laptop..i currently
have quicken 2004 and wanted to give money a try. The
problem is that Money says that the conversion wizard
will not support my 2004 quicken. Anyone now how to get
around this? any help would be greatly appreciated.
Wait until M05 (which, based on history) will be the first Money version to
support Q04 conversion) or use account-by-account QIF export from Q04 and
import to M03.
"Jenni" <email@example.com> wrote in message
> Hi, I just got money ...OL 2003 install over OL2002
I'm currently running OfficeXP(2002). I don't see any compelling reasons to
upgrade to Office2003, except for the Outlook piece. Can I upgrade Outlook
2003 without screwing up the other OfficeXP components?
Yes, but you won't have the option to use Word as your e-mail editor
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Bruce" <firstname.lastname@example.org> wrote in message
> I'm currently...Problem restoring to Money 2005
I had been using an old version of Money - I think it was 99. My computer
crashed. I upgraded to Money 2005 and tried to restore my back up file. I
keep getting an error message that the drive or file is locked for reading.
The file is on my hard drive, neither it nor the drive are locked.
Is there any other way I can access the data?