SQL in Excel data
Is there a possibility/way to run an SQL query in an excel data sheet?
I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.
Advice would be appriciated.
You could use a formula like this ...Change <value> in outlook
We Have Exchange 2003 sp2 and outlook 2003 sp2. I have renamed 2 AD
accounts. Changed all display names, accounts name etc with the 2 accounts.
When users open outlook and send to renamed account they see account name
<oldaccountname> in the autocomplete list. I have cleared nk2 files in
profile , but it still shows newaccount <oldaccountname> in drop down box. Is
there a way to edit the <oldaccountnam> value of the renamed account? I
tried the same thing with a freshly loaded PC. with the same result.
You can delete the nickname files.
MVP - E...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...Changing Interface OWA (exchange 2003)
Not sure if you all remember but back in the Exchange 5.5 days we use to be
able to go onto a site and put in the username of the person mailbox you
want to access, then a windows pop up would come up asking you for your
credentials. I was wondering if that is still possible to do that in
Exchange 2003? If so how can that be done?
Configure Forms-Based Authentication (FBA).
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"John" <firstname.lastname@example.org> wrote in message
> Not sure...Auto formatting features: How do I align page numbers in publicati
I've got a problem with my publication. I can't align even page numbers to
the left without automatic moving the odd numbers to the left as well? Can
someone help me?
> I've got a problem with my publication. I can't align even page numbers to
> the left without automatic moving the odd numbers to the left as well? Can
> someone help me?
You need to create a two-page master rather than a one-page master. What
version of Publisher are you running?
Ed Bennett - MVP Microsoft Publisher
...Change License / Company name
we tried CRM 1.2 with the MSDN license key. Now my company bought a 25 user
Proffesional Suite license and I want to change the key on the production
server. Is there an easy way to do this??
The only solution I see, is via the Data Migration Framework.
How about the re-deploy tool?
"Erik" <none> wrote in message news:u0SXdbXlEHA.3452@TK2MSFTNGP15.phx.gbl...
> we tried CRM 1.2 with the MSDN license key. Now my company bought a 25
> Proffesional Suite license and I want to change the key on the production
> server. Is there an easy wa...gp10 change clients pointing to different server
In version GP 10 I have clients pointed to a test server. When production
server is ready what do i do to point the clients to the production server
Would I change the odbc connection?
Rerun the client installs?
Any help is appriciated.
As long as your production server has THE SAME level service pack as your
clients and THE SAME third party products all you need to do is repoint your
ODBC to the production server.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"2020" wro...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...Background changes conditionally
I have a spreadsheet that shows the floor plan layout of my call
On each desk, the desk number and identity are displayed. I would like
to colour the background for those pcs that are on the same subnet.
I have a sheet called data - it contains Table Number, Desk Number, PC
ID, IP Address.
How could I get it to change the background colour if the pc is on
subnet 162, and set a different colour for those on subnet 167
PeterG's Profile: http://www.excelforum.com/member.p...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be
missing something here. Some data on vendor numbers changed. Let’s say IBM
used to have a vendor number 12345 and now it’s vendor number is 56789. I
can identify IBM as IBM, but I really want to use the number, not the name.
Should I set up a table that ties the numbers together, so that Access knows
12345 = 56789? Or, should I do some kind of Update Query and change all
incidences of 12345 to be 56789? Or, is there some other, method, like a
‘best practices for missing data’?
...Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office
Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders
File (.pst). I understand the basic "Office Outlook Personal Folders File
(.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002
Personal Folders File (.pst) to create a new Outlook .pst file that is
compatible with earlier versions of Outlook."
When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003,
when adding PST's you can chosse either of the two file type options and
browse to chos...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <email@example.com> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...unable to change password via OWA
I am having a problem with users changing passwords via OWA. When they click
on the change password button, it comes up with change password screen and
asked for domain name, user name , old password ,etc. The problem that I have
is that when I submit it, it comes up with message saying "Either the
password is too short or password uniqueness restrictions have not been met."
But I didn't define any password policy on DC.
What can I do ?
Kindly please give me some idea.
If you are running windows and exchange 2003 then there are password
requirements that...find match then change cell value
In column A I have cells filled with text and in column B I have cells filled
with numbers. I need to check if the number in cell C1 equals any of the
numbers in column B. If a match is found then I need to change the text in
column A to CBO.
Column A Column B Column C
aep 5 7
Since the cell C1 = 7 equals the 7 from column B, I need to change the data
in column A from xle to cbo. Is this possible...Find what control is using a data item
I built a form, then deleted 2 columns from the source table and now I get a
popup asking for the value of those 2 columns. The problem is, I don't use
those columns so I need to find what on the form is refferencing the deleted
I have looked at the control drop down on the properties window and the tab
order window and can't find a control with either one of the missing column
How do I determine what is trying to refference the deleted columns?
I found the problem, the column was still referenced in the underlying query
that fed the form.
"MeSteve"...OWA - change password
Getting the "Object Required" error, when somebody is trying to change their
password through OWA. (Win2003/Ex FE 2003)
Any ideas what could be causing this?
Did you follow the steps in:
Pablo D. Vernocchi
Microsoft Exchange MVP
MCSA + M / MCSE + Sec
"Per Hagstrom" <firstname.lastname@example.orgNOSPAM> wrote in message
news:Ojo%23EozNHHA.1240@TK2...How do I delete an auto reply rule from Outlook
I set up an auto reply when I went on holidays. I don't know how I did it,
but I just typed in the message reply and it worked. When I came to delete
the rule, it was not there.
I did not use a template, but somehow I managed to find something that let
me do it. I have tried to replicate the rule, but I still can't.
It is a POP account, but other than that I am not very computor savvy so if
anyone replies, please make it simple!
"grants51" <email@example.com> wrote in message
&g...auto hide toolbar in Excel won't work
I have the toolbar at the bottom of the screen set to 'autohide' but when I'm
in Excel sometimes it does 'hide' until the cursor is moved over it, but
mostly it won't autohide so that I cannot see the Sheet names at the bottom
of the screen. I am running Windows XP Home and Microsoft Office Professional
2003. Can anyone help please?
Every time you move your cursor too far into the bottom area, the toolbar
will pop up. Normally it disappears when you move your cursor up again. If
it does not, try clicking on you spreadsheet. If you right click o...sent and received fields
I've just switched from Outlook Express to Outlook 2000. In one of my
folders, I have sent and received emails that I want to sort together based
on the sent or received date, but all my sent emails sort together because
the received field has no value. And the same for the received emails. Is
there a way to combine these fields or tell Outlook to sort based on both of
them? Do I need to write a VBA macro to accomplish this?
...iisadmpwd change pw gives error
Just cannot get password change to work on Exchange2003 (front-end server) & IIS 6.0
Is this a known issue
Any help would be greatly appreciated.
It could be that you are not (yet) allow to change your password either
because password change is prohibited or because user has to wait for x days
before he is allowed to change his password (domain policies).
Whenever you reset a password for a user and the 'Cannot change pass before
X days' is enforced, the user is not allowed to change it.
"ss" <firstname.lastname@example.org> wrote in message
news...Option for fields to show up in datasheet view
Since most people are more familiar with excel then access, my users prefer
to see it in datasheet view. However, since it could be too long, anyone can
help me how to make an option to show up only field that we can chose in the
I remember there is a sample of database that has that one, but I do not
know where is it now. Please help.
Thanks in advance,
Simplest solution might be to set the Visible property of the controls on
the form, based on the fields the user wants to see.
Allen Browne - Microsoft MVP. Perth, West...Making a template that puts the current date in the document so that does NOT change
I'd like to make a template that sets up some standard headers and
formatting for new Word documents for a night school course I'm
enrolled in. Among other requirements for all papers is to put the
date the paper was created at the top.
I'd furthermore like it so that if I need to reopen the document after
creating it to say print another copy, the date written at the top
will not change. In other words, when I create a new document using
the template the current date is put near the top, but when I
subsequently open the file for editing or reprinting it does NOT