pasting into merged cells #2
Every time I try to copy and paste data into a merged cell I get error
messages about the cells not being the same size. Even if I try to just
paste values only. Is there any workaround or fix for this???
Try pasting into the formula bar. It's a pain, but it
>Every time I try to copy and paste data into a merged
cell I get error
>messages about the cells not being the same size. Even
if I try to just
>paste values only. Is there any workaround or fix for
See my res...Index Match Problem
I'm using the following formula, but it's returning #N/A:
=INDEX('File X'!$F$1:$F$2000,MATCH(1,($B5='File X'!$A$1:$A$2000)*(S$4='File
However, if I replace the S$4 with "7710", it returns the correct value.
The number in S4 is 7710. Why won't the formula recognize the cell
reference, but if I type the contents of the cell manually, it works? I
double-checked to make sure nothing was entered as text.
is 7710 a number typed or imported, check if you don't have blank spaces in
one of the two cells you ...Viewing IMAP messages #2
I connect to a Linux IMAP server remotely for my emails. When I click on an
email in Outlook P once the headers have been updated the system seems to
download the email and the attachement. All I want to do is read the message
before I download the attachment - Is this possible?
Its a bit of a problem if an email has a 3mb attachement and all I want to
do is read the mail content before deciding to download the attachment -
especially a pain if I am CC into some mail.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
I am trying to use Sumproduct with dates that come off an SQL databas
and are in the format of 02/12/2003 15:30.
This is forcing me to use the following formula
where $G3 is 02/12/2003 00:01 and $G2 is 02/12/2003 23:59
Is there any way I can just look at the date only rather than the time
as well, so that anyone can enter a date from, and a date to
~~ Message posted from http://www.ExcelTip.com
~~View and p...Work out overtime hours for individuals #2
I have a question which i am hoping someone will eb able to help me
with, i have a spreadsheet which contains infromation for part time
hours worked during the course of a month for individuals (e.g. below)
Name Start End Hours
Persona 1:30 2:30 1
Persona 3:30 4:30 1
Persona 9:30 11:30
person d etc etc
What i need is a formula that will allo wme to add an extra column
which gives me the total hours person a worked, person be worked and so
on. The original data contains multiple lines (i.e persona could have
10 lines, personb15 lines etc etc), and...Problem with converting Quicken to Money.
I am a new user of Money, I just installed it and converted all of my Quicken
files over. When I began to enter my recipts I was warned that there was
already a weekly "recurring payment" related to that receipt. It ends up
that more then half my receipts got the same warning. When I viewed the
Bills area most days were filled with recurring payments. What is going on?
Anyone else have this problem after converting from Quicken?
...Excel Formulae #2
I have a spreadsheet with value in one column & a series of dates in 5
other columns.For each row depending on the value
in the first colunm a date may be applicable in one or more of the
other columns.e.g 550 in the first column will mean dates will be
inserted in the next 2 columns similar to authority levels. My qn. is
how can I show what's outstanding if the relevant authority levels have
not signed off-basically this is used as a tracker of invoices & I
would like to show what is outstanding awaiting approval at anytime.
----------------------------------...How do I avoid this problem with rule?
I have a rule that looks for "hot" in the subject and moves that message to
a spam folder. The problem is that if photo is in the subject, the rule
sees "hot" in the word photo and moves the message. How can I tell the rule
to look for complete words?
Depending on the version of Outlook, you may be able to use the Exception
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
Brett <email@example.com> asked:
| I have a rule that looks for ...Strange problem in BP Portal for GP10 with Queries
I just had a user come to me and tell me he is getting an error on the sales
page saying the query does not exist. This is the out of the box query that
has not been modified. When I go into query organizer I find the Purchase
Order Line Item folder but it now has a (1) beside it with the query inside
it. What causes the folders to be renamed. While looking at the queries I
multiple folders with the (1) out beside them. Thanks for any information
you can shed on this.
Content-Transfer-...problem with pivot table
I am trying to make a pivot table from my date.
My data includes Names, Dates (which I formatted to month, "m" in the
format cells option)and Amount due.
In designing the pt, I have "Name" in the row field, "Date" in the
columnn field and "Amount due" in the Data field.
I want my data to be grouped as follows:
1 2 3 4
Name $100 $20 $30 $20
Instead I am getting more than 1 month column i.e.
1 1 2 2 2 3
Name $80 $20 $30 $20
Do you know why...Making cards --2 to a 8 1/2 x 11 page
I want to make cards to send out for memorials, etc. I want 2 cards to a
page, top folded 5 1/2 x 8 1/2. What happened to the old Picture It!
Do you want to make these cards in Publisher?
If you do, look at page setup, folded card, tent card, width 4.25, height 5.5.
Publisher will say it will print two pages per sheet
Mary Sauer MSFT MVP
"A Holt" <A Holt@discussions.microsoft.com> wrote in message
>I want t...Synchronize data across 2 sheets
Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers
On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
Not sure if it would help but each record has a unique reference number.
How do i do this ?
Hope this makes sense
thanks for any help offered
If you know which colums are to be changed I would use vlookup function.
Vlookup(lookup valu...MS Office VBA Automation Specialist #2
is there such a certificate? MS Office VBA Automation Specialist, I tried
googling it on microsoft website and couldn't find any info. I just passed
the excel 2k expert exam and I want to take the excel instructor exam, I
haven't however been an instructor. is it possible to take the exam without
an instructor experience?
last but not least, I am thinking about putting together some excel webcasts
for beginners for free. I have always liked to learn by audio/visual versus
reading so I am thinking about implementing this...
here is the link for the first test webcast ...Problem with Pie and Doughnut Charts
I have a couple of doubts in charts:
1) I have a graph where the Column and line charts are plotted on the
same axis. I have got that correctly as well. Now, the problem is I
want to display selective "Data Labels" on the *line graph*. How do I
accomplish this task? (Actually the values for my line graph are same,
hence its just a stright line. And I donot want the same value to be
displayed again and again. I need just one data label on the beginning
of the line)
2) Problem with Doughnut Chart: I have my "Category labels" on multiple
rows (each value is typed in 3 ...Outlook 2002 connector: problem connecting with Domino server because of NAMELookup2 problem
I'm trying to use Outlook 2002 Connector to connect with a Domino R5
server, but I can get no connection.
From the log file I see that the connector uses a NAMELookup2 with the
correct Domino server to get the name of the mail file, but the name
its gets back is corrupted. There are spurious characters at the end
of the mail file name.
From the MSOCLog.txt file
<<67c 25 16:37>> User name : : CN=Jean-Paul Smeets/O=Someorg
<<4f8 25 16:37>> NAMELookup2 called with m_pServerName=someserver
Flags=0 pNameSpaces=0x13646F4 NumNameSpaces=1 pNames=0x12E6CC
NumNames=1 ...Download Trial;
I've been trying to download the trial version of MS
I didn't find a special version for Canadians, though I
saw a special version for the UK, for the US, and for
So I chose international users.
When I downloaded the software, the set up asked for my
country. Canada wasn't listed.
So, my question is this: can I download a trial version
of MS Money 2004 for Canadians, and if so, what is the
AFAIK you need the US version and when downloaded change the currency to
Regar...Intercept file download in IWebBrowser2
I have a MFC application host a webbrowser(IWebBrowser2).Basiclly ,I
hope when user click a file download url(href="test.zip"),I can intercept
the download message and process it by my own download component instead of
Is it possible?
Any article will be help.
"L.J.S" <firstname.lastname@example.org> д����Ϣ����:Oc7j%23OcAFHA.612@TK2MSFTNGP09.phx.gbl...
> I have a MFC application host a webbrowser(IWebBrowser2).Basiclly ,I
> hope ...Help needed with form problem
Workbook contains several forms of varying style
and function. One form shows the results of 10
recent tests in a countdown fashion, showing just
the results of one test, followed by a one-second
delay, followed by just the results of the second
test, and so on until the result of each of the
10 tests has been shown. Then the program
proceeds on to the next step by calling up a
different form. The problem . . .
Sometimes when the program starts running one or
two of the forms are blanked out ("white" with just
the top header showing). The forms continue to
function within the ...Download email #2
How to download email from Microsoft exchange 2000 to
Outlook Express?? without leave a copy at Exchange server.
Outlook Express cannot download mail from Exchange. Why are you trying to
do so without leaving a copy of the mail on Exchange?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Edi asked:
| How to download email from Microsoft exchange 2000 to
| Outlook E...Paper size problem
I want to print flyers using Wizard, on A5 Paper. When I use Special Size on
Page Setup to change to A5 sizes and set Printer Properties to A5 paper in
Print Setup, half the content is not printed. How can I fit the contents of
the flyer to an A5 and print.
I'm on Win. ME, Publisher 2000 and Lex.Z32 Printer.
The flyers are only setup for standard size paper like A4. They are not
able to be changed to A5 paper.
You can open two instances of Publisher so you can copy from the A4 page to
the A5 page and re-size the objects on the A5 page.
The US should free all those
illegally held...Outlook 2000 Password Problem
I have Outlook 2000 on my PC. One feature that I really like is that
can type my password in once and for as long as that particular sessio
is active the program will never ask me for my password again. Once
leave the program the program will then again request the password fo
email authentication. I have just gotten a laptop and I installe
Outlook 2000 on it. The laptop makes me type in the password each time
Is there a way for Outlook 2000 to remember my password each sessio
without checking the Save Password box? Thanks, Chri
~~ Message po...Problems with Using Word as Email Editor
We use Hummingbird DM 188.8.131.52 for our document and record
management. When using this program, it has a problem
with Outlook using Word as an Email Editor. When this is
turned on, it seems that Outlook opens a different
instance of Word. When you try to open or create a word
document, you lose the ability to save or print. These
features return to normal when you uncheck Word as an
Email Editor in Outlook. I have heard that Microsoft was
taking this up with Hummingbird to have them fix it. I am
just wondering if this was to be resolved, or if it is
Hummingbird's problem to ...Field Chooser #2
Guys-is it possible that some of the fields in Outlook
2000 (from Field Chooser) can simply disappear or could
the problem be that somebody else is accessing my mailbox?
It happened to me that the From field and Subject field
have simply disappered twice without my action? Could it
be a bug or something similar?
Is it possible those fields are already in the table view? I've been spooked
by that one before.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstar...XML Entity problem
I am still new to XML and thought I had my solution written, but during the
rollout, we have come up with a problem with actual XML coming in (as
opposed to our test XML).
Some character entities have been transmitted unexpectedly.
' and <
I am loading my XML with XmlDocument, just by
XmlDocument xDoc = new XmlDocument();
xDoc.Load(IncomingFilePath + e.Name);
e is an incoming Fileinfo. My XML does not have any declaration at the top
for a DTD.
I always thought ' and < were understood, but obviously not.
The first line of my incoming XML is <?xml...Problem with .rc files in VS 2005
I have several projects that were created with VS 2003. These are MFC based
applications with .RC files that contain localized strings. Some of these
strings are Japanese, Korean, and Chinese encoded in MBCS. These projects
work fine in VS 2003.
I converted these projects to compile with VS 2005 and if I bring up the
resource editor to view or modify the string resources, VS 2005 will modify
the Japanese, Korean, and Chinese strings. It will replace the characters
with all "?" question marks.
Is there some setting that I need to set to prevent VS from modifying my