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...global catalog connections
lately we are experiencing slow outlook start ups
investigating this I noticed thru the connection status that outlook is
always connecting to an offsite DC instead of the DC in the same site
or the DC at the site of the XC server
our setup is an HQ office with the datacenter holding one XC server and
two GC servers + a number of branch offices each holding a GC server
XC server is 2k7SP1, Outlook clients are all 2k7SP2
what could be the reason of outlook using an offsite GC?
I already checked SPN entries (exchangeAB/server) and updated the
On ...PDOI: Image display.
I hope to be able to display an image. I've looked at and tried to
apply sample code from a number of sources, including Sam's _Teach
Yourself Visual C++ in 21 Days_, an MFC Bible, Jeff Proise's MFC book,
I would like to set up an array as follows
data = 0;
data = 0;
data = 255;
to draw a red square, rect, or triangle. Once I see I can control
pixel values, invoke the CBitmap class and control the display of the
pixels, I'll worry about the code that reads the image file to be
Can someone point me in the right direction.
I also started a basic M...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
...how to use STATIC control to display temperature in degree (oC)?
I want to use the Static control as a label to display temperature unit
in degree (that is oC). How to do that?
"kathy" <email@example.com> wrote in message
> I want to use the Static control as a label to display temperature unit
> in degree (that is oC). How to do that?
I cannot get at the messages stored in one of my e-mail folders. It's
called "Personal" When I click on the folder in the "All Mail Folders"
view, the message area goes grey with a heading nof "Unable to disply
the folder". The toolbars and normal mail options go away, too.
There are sub-folders to Personal folder, and I could move the
sub-folders to a different location. They and the messages in them
When I right-click on Personal and go to the Property tab, it looks to
me like all of the other mail folders. When I toggled "Show number of...Close Connection Question
I use transferspreadsheet (link) to bring Excel sheets into my managers
database. I have gone into Excel and set the sheets to shared but still some
users who try to access that same sheet will get a message that it is in use
by another user, which causes their computer to put up the debug message. Is
it possible to close that connection after the sheet has been linked and
updated the table? Or is there a better way? Or would it be possible to have
each user load their own copy? What is the best solution for this? Thanks,
State of Arkansas
no s...Some text displays as #################
I have an Excel (2007) sheet with three columns. All are formatted as
text. In some rows, the third column contains several hundred
characters. Those cells display as ################, but if I select
that cell, the display window above shoes the actual data and if I
press F2, I can see all of the data.
This would not be a problem, but when I export this sheet, the csv
file contains the ##########s and not the actual data.
What am I doing wrong?
"Prof Wonmug" <firstname.lastname@example.org> wrote in message
>I have an Excel (2007) sheet ...Display text with Unicode format (ex: Chinese) on controls written by VC6.0
We can write a project with Debug-Unicode mode and display text with Unicode
format? Ex: Chinese or Japanese
>We can write a project with Debug-Unicode mode and display text with Unicode
>format? Ex: Chinese or Japanese
With VC6 you can build a debug (or release) Unicode project that when
run on a proper Unicode platform (like XP) should be able to display
Chinese or Japanese texts (providing the font you're using has the
Tittle bar, menu, button can display text with Unicode format when i build a
debug Unicode project? We can use fo...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.
...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...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...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...Portfolio manager and same security display problem
I am using Money 2008 Plus Deluxe.
I have investment in Mutual Fund which is held partly directly with
the Fund Manager and partly with a Fund supermarket.
There are two seperate accounts list to manager this.
In the Portfolio Manager, I want to show these as seperate items but
Money will not allow me to use the same symbol for it. Is there a way
Alternatively, how can I 2group" both these accounts as one in
In microsoft.public.money, email@example.com wrote:
>I am using Money 2008 Plus Deluxe.
>I have investment in Mutual Fund which is ...Entourage 2008 Web Services edition (13.0.3) and " Unable to establish a secure connection" error
One of our users had his Entourage 2008 upgraded to EWS (13.0.3). He is
using Leopard 10.5.8. Since the upgrade he is getting an error/warning
message after he provides his login credentials:
"Unable to establish a secure connection to exchnlb.txstate.edu because the
server name or IP address does not match the name or IP address of the
This looks very similar to an issue that was address by the 12.1.2 update.
There are no reports of other users which this issue. I use the same
version of EWS as the user.
There is an ability to capture i...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...Open a Report with two different forms
I have a report (rptRepairRequest) that I have command button that
prints it out from a form based on the ID of that form. This works
fine. What I would like, and not sure if it is possible, is to have
another form where I can just select the ID from a drop-down and open
the same report.
My record source for the report is currently:
SELECT tblRepairList.* FROM tblRepairList WHERE
I tried adding an OR statement at the end:
but it asks me for '...re re re ????
When I receive an email I can see all the 'To's' in the preview panel but
when I open the mail message all I see is the 'From'. Is there a display
setting so that I can see all the 'To's' when I open the mail mesage and
I have looked and can't find a display setting for this. I'm using Microsoft
Thanks for any help.
...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, ...View two page spread?
I clicked on View>two page spread because I want to view both sides of a
single sheet at the same time. However, the view does not change even though
there is a check mark next to the command.
Shouldn't I be able to view both sides of a sheet at once?
Catt <Catt@discussions.microsoft.com> was very recently heard to utter:
> I clicked on View>two page spread because I want to view both sides
> of a single sheet at the same time. However, the view does not
> change even though there is a check mark next to the command.
> Shouldn't I be able t...