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...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...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!
...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" <firstname.lastname@example.org> 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...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 ...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 ...)
...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...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...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....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" <email@example.com>...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" <firstname.lastname@example.org> 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...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.
...Formatting Date in Header or Footer
How can I change the default date format (8/18/2004) in the header/footer to
a different date format (18-Sep-04)? Is there a way without using VBA?
see your other post
"Emile Zac" <email@example.com> schrieb im Newsbeitrag
> How can I change the default date format (8/18/2004) in the
> a different date format (18-Sep-04)? Is there a way without using
...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...finding a cell of a particular color
I would like to make a SUMIF on cells formatted is some ways (font,
background color, character color, ...)
So it would only sum the cells that are written in dark blue for example.
I hav searched but didn't find any function to test that, but I know there
should be one because I can make a 'FIND' on those cells.
Of course I'll have to know the color codes or names ..
Thanks for your help,
see response in programming
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
&qu...Conditional formatting of an entire row based on a cell text entry
Hi everyone, I would like to use conditional formatting on a table that is 8
columns wide and 50 rows high.
What I would like to do is colour all rows that have an X in column D or E.
This is what I tried The formula is =A1="x"
This colours only the cells where there is an X. What I would like is the
entire row or rows to be coloured.
Thanks for your efforts
Try setting to The formula is =OR($D1="X",$E1="X")
The mixed reference will allow you to copy this to your entire table,
keeping the references fixed to column D or E of the current row.
&qu...how to keep text with next paragraph
"Church Mouse" wrote:
What is the problem? Version?
...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