Auto Filter problem
I am using the auto filter for a particular column to sort out differen
medical programs. When I click the drop down and click a program, i
doesnt show me ALL the lines that say this particular program. Why is
Message posted from http://www.ExcelForum.com
maybe some hidden characters in these lines 8e.g. additional space
"jkb724 >" <<firstname.lastname@example.org> schrieb im
> I am using the auto filter for a particular column to so...cannot open or reply to a message or new message
Have just upgraded to windows 7 and now when we are in outlook 2007 we
recieve mail but cannot reply, open or forward mail. It is open in the task
bar but will not open up full screen.
Any help here would be grateful.
Close Outlook. Open it in safe mode.
Start > Start Search > outlook.exe /safe
(please note the space between outlook.exe and /safe)
Does this behaviour continue?
"Cazz" <Cazz@discussions.microsoft.com> wrote in message
> Have just upgraded to windows 7 and now when we are in ...Auto-Editing
Word 2003 has a very annoying default. It assumes too much! If I reformat a
few words in a document, it changes the entire document to that formatting.
Grr-rrr-r! I have to constantly press undo to get what I want. I know
there's a feature that's causing this annoyance but I can't find it to turn
it off! Can anyone help, please?
Microsoft Word MVP
"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
news:CD959D82-F81B-4A9D-993E-73...outlook2003 forwarding (always attaches rather than open)
I have a friend that has the same Outlook 2003 that I do.
But when they forward, the email client always attaches the
message as an attachment so they can't clean it up prior to
I can't find the option to make theirs work like mine (which
doesn't attach forwarded messages).
"joe" <email@example.com> wrote in message
>I have a friend that has the same Outlook 2003 that I do.
> But when they forward, the email client always attaches the
> message as an attachment so they can...Auto-Calculate
I have a spreadsheet that utilize the stock quote add-in from MSN. On a daily basis I refresh the add-in functions for the Highs, Lows, Last, Volume, etc. On occasion the spreadsheet reverts to manual caculation settings, and I have to press the F9 even after I updated the quotes. I've always preferred the any spreadsheets I open, blank or otherwise, the automatic setting selected for calculations. I consider this an annoyance. Has anyone experienced this glitch? Is there a fix for it?
Excel takes the calculation mode from the first workbook that opens in a
Sub...auto copy self
How do I arrange for Outlook to automatically copy myself
on every new, reply or forward email?
If you mean keep a copy of all sent, see settings under Tools/Options/Email
Options and Advanced Options
"rich" <firstname.lastname@example.org> wrote in message
> How do I arrange for Outlook to automatically copy myself
> on every new, reply or forward email?
...When opening MS Outlook 2002 a window opens asking for network server?
Office XP Professional
When I open MS Outlook a window opens up that is titled
Microsoft LDAP Directory It asks for a server name, user
This is a stand alone computer. Not on a network. Is
there anyway of stopping this window from opening up each
time I start Outlook?
Thank You for your time
Your Outlook is configured to use an LDAP server for some
To remove the settings for an LDAP server, goto:
Once in the Email-Accts window you will see four radio
buttons(2 for E-mail and 2 for Directory) Click on the
button next ...empty replies
I have Vista windows mail, lately my replies are empty. Also recently having
trouble printing. Any help would be appreciated. thanks.
Although these are OE problems, they likely relate to yours. See points =
11 and 12 here: www.oehelp.com/OETips.aspx#10
Also see point 3 on that page, as something could be interfering.
"jo2cat" <email@example.com> wrote in message =
>I have Vista windows mail, lately my replies are empty. Also recently =
> trouble printing. Any help wo...Auto correct or Auto complete
We are all familiar witht he auto correct or auto complete functions found in
MS applications. Of course that means it is available in Access also. My
question is this ... can this function be replicated within the DB, so that
the set of auto correct items are part of the package rather than something
that would have to be set up on each individual desktop system?
It's use, for me, would primarily be within a memo field where medical
abreviations, used as a shortcut, would convert to the true meaning as the
user types them in. Ex: "prn" without quotes would change to. &qu...Auto Scale Chart Macro -- Any improvements please?
This is the best way I've found to correctly scale a chart -- the only way I
found to exclude a chart interpolating with #NA cells was to delete those
cells containing #NA, and run the chart. This takes a long time on my
computer. Wondering if there is a better way. This macro is directly taken
from 2 excel mvps and modified; i believe a mehta and ron bovarty, but could
be wrong. Thanks for taking a look.
Dim ValuesArray(), SeriesValues As Variant
Dim Ctr As Integer, TotCtr As Integer
Applic...Cannot open files.
I am having trouble opening files after saving them. I keep getting the
message "cannot be opened because there are problems with the contents.
Details says "Unspecified error" followed with the location in the
...OWA auto login
I am trying to use the credentials from the forms authentication login to
automaticaly log in to Outlook Web. I redirect to a URL with this format:
I have seen this example in other posts but this does not work for me. I
still get the Outlook Windows Login prompt.
Perecli Manole wrote:
> I am trying to use the credentials from the forms authentication
> login to automaticaly log in to Outlook Web. I redirect to a URL with
> this format: http://UserName:Password@mailserver/exchange
> I have seen this example in other posts but t...data missing in charts original file 97-2003 opened 2007 and then.
I have a file that is created in 97-2003, after it is opened in excel 2007
and then saved back to 97-2003 version when it is reopened the charts that
are included are not showing any of the text data or information that was
added to the charts. Anyone else have this problem or know how to fix it
other than manually updating the charts.
Did you add the information with XL2007? If so maybe you used components
that are available only in that version. Did you get a warning that saving
in the older format will lead to loss of information? If you don't remember
you may want to go thr...Blocking Out of Office replies to Internet
I know the default on Exchange 2000 is to not allow Out of Office replies
outside the Exchange organization. I am taking some flak from "Power Users"
who say they need this functionality. My arguements for not turning it on are
1. Potential message looping
2. Spammers can validate the existance of valid email addresses.
Does anyone have any concrete locations of official policy (e.g. Micorsoft
KBs, security best practices) on this issue so I can direct my management to?
I don't think you'll find a Best Practice, as this really pertains more to
company need. ...Opening another user mailbox
I am trying to setup outlook to open another user mailbox in addition to my
own. In the Outlook I do this:
Tools->Options->Mail Setup->Email accounts->View or Change->Change->More
settings->Advanced->Open these additional mailboxes->Add
The problem is if the user is not in the GAL - I cannot perform this
As soon as I uncheck "Hide from GAL" in the user properties I can open his
I need to hide user from GAL but still get access to his mailbox.
How can I do it?
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet...Auto look through subfolders
I can write a macro that will extract data from all excel files in a
What I need to be able to do is write a macro that will automatically
extract data from excel files within folders and sub folders and sub
sub folders etc
For example the data is all held on the following directory:
H:\development forms\2006 cost sheets\
And within that directory by customer - for example Tesco, Boots, Asda
etc. These customers are then subdivided into product ranges - eg
1,2,3,4 etc and some futher subdivided by national or exclusive. All
the excel files are in exactly th...Any way to get rid of an auto-suggestion in the login dialog box, for Exchange/OL using RPC over HTTP?
A client was using RPC over HTTP to two different Exchange servers (OL
prompting for profile on startup). Both profiles were set up to prompt for
credentials upon connection to Exchange.
There's now only one Outlook profile needed; the other is gone and OL isn't
prompting for the profile selection any longer, which is fine.
However, Outlook is remembering domain1\user and domain2\user in the login
dialog box, and I'd love to be able to get rid of the no-longer-valid
credential dropdown suggestion.
(The computer is not a member of a domain and hence always needs to be
prom...An auto reply to an auto reply!
Had the funniest situation yesterday.
Somebody emailed a public folder we have set up.
On there we have a rule to send a reply saying thanks for your
email -someone will be with you shortly (we have to have this message on -
it is for some website that recently went live).
Now that auto reply went back to the guy who emailed - who must have sent it
from a public folder himself (as he forwarded the original email from a
The guy received our auto reply - and promptly his email system sent an auto
reply to us.
As is the way it is set up - our email system sent him an auto ...2 workbooks open
A co-worker created a spreadsheet - over the course of a few weeks, several
tabs were added. Recently, when I received the spreadsheet via email, 2
identical workbooks opened. The 1st workbook was called 'Data (1)' and the
2nd was called 'Data (2)'.
There wasn't a macro on either spreadsheet - I'm at a loss to why 2
identical workbooks opened. Any ideas or suggestions are appreciated.
Close the second instance of the Workbook and then Save the file.
> Hi -
> A co-worker created a spreadsheet - over the cou...Auto date
I am trying to create a field in a form that if anything is changed on it, it
will automatically update the date to current date. Is this possible?
>I am trying to create a field in a form that if anything is changed on it, it
>will automatically update the date to current date. Is this possible?
Make sure the last changed date/time field is in the form's
record source table/query. Then use the form's BeforeUpdate
Me.lastchanged = Now
MVP [MS Access]
You can do this in the On Dirty event of the form, which fires as soon as you
m..."from" account when hit reply
When i reply to any message - no matter which account the
message was sent to (i have two different accounts - 2
different email addresses coming into same place) it
always lists "A" address, even though "B" is my default,
and I have entered "A" as the reply address in my account
settings for BOTH addresses.
i am using outlook express.
anyone know the answer? i am sending hundreds of replys
and dont want to have to keep clicking the other account
thank you very much,
"trixie" <firstname.lastname@example.org> wrote...doc attachments won't open
I have Word 2007 and when someone sends a *.doc attachment it won't open.
If you copy it to the desktop or somewhere else, it opens fine. I did check
programs and Word is set to open .doc files
Opening an attachment without saving it first is asking for trouble.
Any editing you do to it won't be saved, since it's just sitting in a
temporary folder that gets deleted when you exit Word.
On Nov 21, 6:32=A0pm, tomg88 <tom...@discussions.microsoft.com> wrote:
> I have Word 2007 and when someone sends a =A0*.doc attachment it won't op=
> If you...files can't be open in excel2000
I have some excel files which works fine on office 97
with windows nt. but when I try to open them in office
2000 with windows 2000 it just gives me a blank page. this
file is with macros. pls help.
does this only happen if you try to open this file from the Windows
Explorer?. Have you tried to open this file from the Excel File menu?
"shah" <email@example.com> schrieb im Newsbeitrag
> I have some excel files which works fine on office 97
> with wi...Outlook 2002 Hangs on Replying to Email
I have a PC running Win2000 Professional and Office XP SBE.
Outlook default to using Word as Email Editor, but NOT to
use Word to read RTF.
There is one particular email which is in htm format. When
clicked on Reply, Outlook will hang, and the computer
becomes very sluggish. Task Manager shows Winword process
is using 100% CPU. To recover from the situation, the
Winword process has to be killed.
With other emails there is no problem whatsoever.
There is an KB article (811946) that seems to cover this,
and it refers to a hotfix.
Any comments on similar experience would be welcomed. And ...Why do my excel documents not open from the desktop?
Why do my excel documents not open from the desktop? I can only open
documents when I am already in Excel. I assume some setting is off. Where
should I look? Thanks
Try the usual fix(es) for this problem.
Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again
If this doesn't work try to re-register Excel
Close Excel first and
On the Windows Taskbar
1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have ...