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...Moving windows
how to get notified of a parent window beeing moved within a child window?
You can't. What you have to do is have the parent window enumerate its child windows and
send them a user-defined message indicating the parent has moved.
On Tue, 26 Aug 2003 17:52:33 +0200, "Philipp Huber" <firstname.lastname@example.org> wrote:
>how to get notified of a parent window beeing moved within a child window?
Joseph M. Newcomer [MVP]
MVP Tips: http://www.flo...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
...Solution for: Windows XP (NL): Windows Activation Problem + Windows Automatic Update Problem = Very Slow Computer.
I think I have found a solution on the internet, I will sum it up
shortly because the description wasn't that accurate, my description
will be more accurate with additional information about what I think
might have happened, but first a little story what I wanted to do
Today I wanted to try and install Service Pack 3 for Windows XP dutch
This was not possible because Windows Automatic Updates was required
by the Microsoft website to be able to download it and windows
automatic updates is malfunctioning, so that became a short attempt.
Then I decided to ...Outlook 2007 Crashes when opening in Windows 7 64 bit
The computer is new with windows 7. I downloaded Office 2007 standard a month
ago. It has been working fine. Yesterday i was downloading old printer
drivers and my machine took a "critical update" from Microsoft. After that my
Outlook would not open. It would start to open and rthen crash with the error
message "Cannot start Microsoft Outlook. Cannot open the Outlook window." All
other MSD Office programs are working fine. Any suggestions?
...Alt Key Forces Step Through Windows?
I've been programming VC++ for years, yet this is the first time I
encountered this situation. I'm running a program and I have to press
the alt key before each window shows up. I'd like this behavior to
stop. I'm running VC++ 6 on a Windows XP system on a dialog based
application using MFC. Any help would be greatly appreciated.
Thanks in advance.
> Good Morning,
> I've been programming VC++ for years, yet this is the first time I
> encountered this situation. I'm running a program and I have to press...Help! #7
After I change the value of a cell, the reference cell doesn't change
Any idea how this could happen?
Thanks for your help.
Try selecting Options from the Tools menu. Then go to the Calculation tab.
Calculation should be set to Automatic.
> After I change the value of a cell, the reference cell doesn't change
> Any idea how this could happen?
> Thanks for your help.
...Sending email's from window mail
I have been trying to set up window mail so I can send emails straight from
word. I am having the error message:
"The host 'POP3' could not be found. Please verify that you have entered the
server name correctly.
Subject 'Resume may 2010', Account: 'POP3', Server: 'POP3', Protocol: SMTP,
Port: 25, Secure(SSL): No, Socket Error: 11001, Error Number: 0x800CCC0D"
come up. I do not know how to set this up. What information do I put in the
box where it ask what type of server my email address uses (ie. POP3,) and
how do I find this informatio...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,...how do I change the dektop icon for windows word
Not a Word issue. It's a function of Windows.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Bill" <Bill@discussions.microsoft.com> wrote in message
Right-click on icon > Properties > Change Icon
"Bill" <Bill@discussions.microsoft.com> wrote in message
news:FCD9D7DE-1AFA-471A-9327-ABD18F918A67@micros...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.
...Connect Windows 7 to SBS 2003
Spent the last eight hours trying to connect my W7 workstation to a fresh
install of SBS 2003 premium. When running http://server/connectcomputer/, I
would get as far as providing a username and password for setup when a popup
would inform me, "The list of users and computers could not be found. Make
sure that the Small Business Server network adapters are configured
correctly.". I have only one NIC, I can see the shared folders on my server
and even connect to them. My server is not running DHCP or DNS and I think
these might be my problem. I did run windows update and...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...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...Windows 7 Pro 64-bit and RMS 1.3R
Not sure if it can be done, but no matter what i try, installed sql2k5,
updates, run in compatibility mode (Win XP SP2), and I always get the same
message - ...Store Operations install interupted...
I just need to run the manager (from the backoffice)....any ideas?
We have had the same results. We think it is more to do with 64-bit than it
does Windows 7.
Retail Information Technology Enterprises
"Angelo" <Angelo@discussions.microsoft.com> wrote...Linking checkboxes to multiple worksheets
How do you link a checkbox from one worksheet to multiple worksheets
within the same workbook?
The checkboxes were made from the control toolbar.
I am new to visual basic and was able to connect multiple checkboxes
within the same work sheet using a simple value command but now I
need to link it to other sheets.
Why not just link the checkbox to a cell on a single worksheet and then use a
formula on the other sheets that refers to that linked cell?
If you go into design mode (an icon also on the Control Toolbox toolbar), you
can rightclick on the checkbox and select pro...Office Windows not visible
Operating System: Mac OS X 10.5 (Leopard)
I have just installed the 2008 version but it was happening in my 2004 version too.
When i open a document it doesn't show up / you can't see it.
it is listed under 'window' as being open
have to click click click around and don't even know what i last clicked on to get it to randomly appear, if at all....
in the 2004 version when it started doing it, i could go to 'window' and click 'bring all to front' but it doesn't work in 2008.
its driving me nuts! any ideas what is happe...Opening a PDF link inside of an arriving email on the back ground.
I do receive fax to my email. Inside of this coming email there is link to
a PDF file. I would like to open that pdf link on the background and scan it
and if I see certain words in that PDF file, I would like to move it special
Jeff B Paarsa
You'd need a com addin to do this - simple rules won't work.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a week...re re re ????
...changing window size by dragging the border of the window
I wanna change the window size by dragging the border of the window
with the mouse. Is there a mfc routine which resizes the window size
Thx for every help!!
> I wanna change the window size by dragging the border of the window
> with the mouse. Is there a mfc routine which resizes the window size
The window must have the specific style WS_THICKFRAME! When this style
is set windows allows the window to be resized.
What kind of winodw do you have? A Dialog. In this case you will find
some good helper at www.codepr...using ms access as database in windows appplication
i gets " unspecified error" when i inserts new data to database and when i
fetches the data from access database is it the problem from access
No one here can see your monitor....
Please provide Windows version, Access version and what you are doing at the
time of the error (ie. opening a form, running a query, etc...). Posting
that information increases your odds of getting assistance.
"I feel I have been denied critical, need to know, information!" - Tremors
"access error" <access email@example.com> ...