Outlook keeps prompting for logon..
User is on Outlook 2k3, latest service packs, updates, etc. Mailbox lives
on Exchange 2007 (SP1). Everytime the user starts Outlook they're prompted
to logon. I've disabled the logon prompt at startup option (and enabled it
and then disabled it again), but it's still happening.
I've tried it with cached mode on and cached mode off.
I've tried it with offline mode enabled and disabled.
I've tried deleting his profile and recreating it.
I've tried switching to an RPC/HTTPS connection.
Finally, i completely uninstalled Outlook 2k3 and installed Outlook 2k7.
Not...Help Old addresses keep coming up
When I go to send an email to some people their old email addresses keep
popping up together with their current ones. I do not have them listed in
contacts or in an address book. It is a minor annoyance. I am using Outlook
2003. It is a minor annoyance. How do I delete these old addresses? Where
they show up is where I am entering the e-mail address on the item being
You did not specify how you were entering the addresses. Presumably you are
using autocompletion and they are...Selecting cell with mouse
I have a spreadsheet that allows me to move to cells locked or unlocked with
the cursor but doesn't allow me to use the mouse. I'd thought that the
range of what could be selected had been restricted using vba but this isn't
the case, I've opened the file and disabled vba and still can't select the
unlocked cells with the mouse. If I unprotect the worksheet, then all works
I'm at a loss!
Any pointed most welcome. Rob
I've never seen excel allow you to select a cell with the arrow keys, but not
My first thought w...Use a cell's value as row number for another cell in Excel
Excel XP: I'm trying to use the values in one row of cells (D1:F1) as the
reference for the row value for a different series of cells (D2:F4). For
Column A B C D E F
Row 1 1000 30 170 1 2 3
2 1500 60 190
3 1200 20 175
I want to get the following cells to equal:
D2=1000 (In other words: D2 = A1); D3=30 (In other words: F2 = B1);
E2=1500 (In other words: E2 = A2); E3=60 (In other words: F2 = B2);
F2=1200 (In other words: F2 = A3); F3=20 ...Cell color change referencing the date in designated cell
How can I have fill color of cell change according to due date. In
example, red overdue, green - on time, black complete.
Use Conditional Formatting. You'll need to determine what is Overdue,
On-time and Complete
Read up on the help and come back for specific help
"Klonja" <email@example.com> wrote in message
> How can I have fill color of cell change according to due date. In
> example, red overdue, green - on time, black complete.
> Thanks, K
Hi Cl...Confirmation of receipt keeps trying to send and fails
I received an email message that requested a confirmation that it had been
received. I told it to send confirmation, but it failed when attemtping to
send it and produced an error.
I tried deleting the email message and everything in the draft items and
Outbox, but every time I switch on Outlook the darn thing tries to send this
email confirmation. It seems there is nothing I can do to stop it, even
though I cannot see it!
I have tried uninstalling Office 2003 and reinstalling it, but all of my
settings are remembered as are all the old emails. I just cannot seem to
get rid of it!
...how to enter a value, and have it SUMMED with the existing cell co
An Excel cell contains, say= 4. How do you enter, say=2, and have the result
(not COPYING and Paste As ...)
...copying cells #2
In cell A1 sheet1 I have a number which lets say represents a code for a
specific shape that i have allready drawn in cell B1 in sheet2.Can you please
tell me what kind of instruction i can give to cell B1,sheet1,so that i can
get that shape from cell B1 sheet2 into B1 sheet1?
How about putting those shapes on Sheet1 and hide them. Then you could have a
macro unhide the one you want.
J.E. McGimpsey shares this in a macro at his site:
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcrit...Keep Lines Together; Keep with Next
I'm working in Vista. When I select lines and click on "Keep Lines
Together," the lines do not stay together. They stay together if I also
click "Keep with Next," but I'm working on a booklet in which the pages are
1/4 of a letter-sized page, and a lot of space (4 lines) is left at the
bottom and wasted if I also click "Keep with Next." Why won't "Keep Lines
Together" keep the lines together? The project is a small, bound country
club booklet, with names, addresses, phones, etc. Each entry might be 2, 3,
or 4 lines. Any h...Cannot Receive emails from certain people!
Around two months ago one of our clients mysteriously started being
unable to receive emails from around 4 users they could still receive
emails from everyone else , so we thought it was a mail server
So we moved the emails to a new server and there still having the same
issues. We have tried sending emails through AOL,Hotmail,Yahoo, O2 and
our own email and they all go through fine , but these for compines
which just happen to be there major clients keep getting this error-
Your message did not reach some or all of the intended recipients.
Subject: RE: email
Sent:...why do my pictures keep disappearing?
Although I have checked the box in 'pictures' any form of graphic or word art
that I have inserted into my publication keeps disappearing! If I click in
the general direction of the insertion the bounding dots appear, but no
Are you sure you have view, pictures, detailed display checked? If so try updating
your graphics driver...
Mary Sauer MS MVP
"JG" <JG@discussions.microsoft.com> wrote in message
> Altho...cell content
How do I get the content of list box?
I clicked the cell after = sign to display the content, but it displayed 0.
...custom a cell
How do make that when I enter 1234 its should come out 12.3
shlomo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1530
View this thread: http://www.excelforum.com/showthread.php?threadid=34680
Format > Cell > Number > change decimal and symbol
Cissy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20107
View this thread: http://www.excelforum.com/showthread....Moving my files to a new computer
So I've copied my old .pst file to my new computer, used Tools>options>mail
setup>data files to introduce outlook to it, and reset it to to default and
removed the old entry so there is just the one entry in the list. Both my
new and old outlooks are 2003.
So far so good and I can see my mail folders and contacts in the left hand
pane, *but* tools>address book is not showing any of my contact addresses,
nor will check names show them. Anyone know whay or can point me at an
article that tells me what to do?
Also, I have several email accounts is there an easy way of movi...how can I keep a tab in place?
I have workbooks with multiple worksheets. I would like to keep the summary
tab in a fixed (first) position so that the user can easily, quickly find it
without using the l<, <, >, >l (arrow) tabs.
I use hyperlinks to get from the summary tab to the other tabs, and I know I
can hyperlink tab back... but I'd rather not use the hyperlinks too much.
Tools - Protection - Protect workbook (for structure)
Or, create a custom button/macro that navigates to the summary sheet.
"missy8892" <firstname.lastname@example.org>...execute macro at certain time
I would like to have a macro execute automatically at a certain time
each day. Does anyone know if this is possible?
Message posted from http://www.ExcelTip.com/
-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/
You gonna keep excel open?
If yes, take a look at Chip Pearson's notes:
You also may want to look at a sc...Flashing cell contents
Using Excel XP. Is it possible for certain text or numbers to flash or
blink? For example, if any numbers in A1:A10 has a value of 100 or more I
would like the number to flash or blink.
Thank you for any help,
Not possible. Most people would hate it if spreadsheets flashed or blinked, and if I use
all my available empathy I believe I could understand them.
HTH. Best wishes Harald
Followup to newsgroup only please.
"Mike" <email@example.com> wrote in message news:rJ6zb.76747$xV6.18222@lakeread04...
> Hello All,
> Using Excel X...Outlook 2003 keeps asking for password for POP3 account
I am running WinXP Pro and Office 2003. My Outlook 2003
keeps popping up intermittently a pop-up box requesting
me to re-enter the POP3 account password. Now, there is
nothing wrong with the password already entered (check
box to save password), so all i am having to do is click
OK, but it is really annoying. Does anyone know what i
can do to stop Outlook from doing this?
Thanks for your help.
...How do I keep the home tool bar on top
An hour ago the home tool bar stoped being displayed. I can restore it but
every time i hit a key the tool bar disapers. How do I keep the tool bar on
top while I am typing.
You've minimized the Ribbon. Double-click any tab on the Ribbon to restore
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"RobertTaylor" <RobertTaylor@discussions.microsoft.com> wrote in message
> An hour ago the home tool bar stoped being displayed. I can rest...Cell Spacing Problem
I'm having a problem with a file that's used around our office fo
record keeping. On everyone else's computer (running Win2K and Offic
2000), the file fits on one page and looks fine when printed. O
another computer (running WinXP and Office 2000) it also looks/print
This brings me to my computer (IBM Thinkpad T41) running (WinXP).
Originally I installed Office 2003 and when I opened the file tha
everyone else used, it no longer fit on 1 page. I double checked th
margins and column widths and they were all the same. But visuall
speaking, it was obvious that my c...How to keep userform always on the top of all windows application
Is there some that when I execute an excel user form, it *remains o
the top * of all the windows applications that are currently running
until & unless I, manually, minimize or close it.
JAtz_DA_WAY's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2668
View this thread: http://www.excelforum.com/showthread.php?threadid=40059
You may get an answer to your question--but it'll involve both making the
userform always on top plus adding those minim...skip cells with zero values in chart (cells not empty)
I don't want to display zeros in my line chart. The cells are not empty -
they contain a formula. I have used a simple if statement to hide a zero
value - however the chart is still showing the datapoint as zero.
What does your IF statement produce? If it gives an empty string "", then
it will be treated as zero. Change the "" to NA(). If you want to hide the
NA() values in the worksheet, you can do that by conditional formatting.
"jhall@ifox" <jhall@firstname.lastname@example.org> wrote in message
news:3DFD839D-40AD-4696-B...Keep it alive
Is it possible to declare an Access.Application object in a module of
another db (let's call it db1), display the application window to the user
interface and keep it alive even when db1 is closed?
Because the database object is closed as soon as the memory used by db1 is
Thanks for any suggestion!
Answered in another group where you posted this.
...Formula refers to empty cells even when cells contains data
I have a worksheet with link to external data source. The option is enabled
to ask me to enable auto refresh or disable auto refresh.
I have used 'Sumif' and 'vlookup' function to calculate certain values. Now,
even when the data is available in cells, the error checking option shows me
a little green flag with error as 'Formula refers to empty cells'.
I do not understand why the error is coming.
There is another problem in the worksheet that is even when i disable auto
refresh i still change my values that was there when i saved the worksheet
last ...How do I enter a formula in a cell so that letters= a number i.e..
How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.
Change 'cell_ref' to the cell with a letter in.
> How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.
See one response in your identical post in .newusers
(Please do not multi-post)
GMT+8, 1� 22' N 103� 45' E
"Alex" <Alex@discussions.microsoft.com> wrote in message