Opening Excel files in Explorer
Usually you can open any excel file by double clicking the file from within
Windows Explorer. Since some time for a mysterious reason this doesn't work
any more. Excel opens but not the file. Any ideas why this is so and what to
do about it?
Tanks for info,
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run
The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults...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...Excel File Opening Via Hyperlink
What do I need to do within an Excel document to have it open in print
preview mode when the Intranet link to this file is clicked?
Put this one line Macro in the ThisWorkbook code area:
Private Sub Workbook_Open()
Gary''s Student - gsnu200723
...How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
The = icon disappeared in newer versions of excel (xl2002???).
You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)
And drag it to your fav...Outlook Error #55
When I send or receive messages using Outlook xp I get the following error
If you're using one of the more popular internet service providers or
web-based e-mail providers, one of the articles on the following page might
help you troubleshoot your authentication issue:
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***
> When I send or...Formula error since 10.5.6 update ...
I have been working with a spreadsheet for years without any problem
of this sort. Since my recent 10.5.6 upgrade a part of a formula
not return a correct result.
My problem seems to be related to the incorrect result of this part
my formula: TEXTE($N$5;"dd-mm-yy"). In this example, N5 is equal to
"31-10-09". This formula should return : 31-10-09 It returns
yy". Funny, the "31" is replaced by "dd" and "09" by "yy", while the
month number is correct.
Any idea with this is all about ? ...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!
...getting date and time information- Masking?
I have the following data that I want to mask off the minutes and seconds -
yet keep the hour and am/pm how do I do that?
Let go, Elevate your life
(format as time including AM/PM)
If I understand what you mean by mask.
Brent Hauver wrote:
> I have the following data that I want to mask off the minutes and seconds -
> yet keep the hour...Open to null 04-13-07
Does anyone have some advice/trick on getting a Form to open with
nothing in its controls/fields?
I have Form based on a Table. The Form has a combo box to look up
I would like the Form to open without a record in it; when the user
selects a record ID from the drop-down-list, a record then appears.
> Does anyone have some advice/trick on getting a Form to open with
> nothing in its controls/fields?
Use a condition like
SELECT * FROM [yourTable] WHERE 0 = 1
in the RecordSource.
--> stefan <--
If you make the subform a c...update a list box on a tab
I have a form that has a Tab control. On the second tab i have a list box.
When the data on the main form is updated i need to update the Tab control's
list box. Any ideas??
On Nov 14, 8:59 am, Joe C <J...@discussions.microsoft.com> wrote:
> I have a form that has a Tab control. On the second tab i have a list box.
> When the data on the main form is updated i need to update the Tab control's
> list box. Any ideas??
Hello JC. You can go to the properties of a field that you update on
the main form and choose &...I cant get my email through aol on outlook
I set up my accounts while using outlook but I cant send emails, or recieve
any emails without going to other on line sites such as aol, hotmail, I have
checked and re-checked but still unable to send or recieve any emails
Need more info - what version of OUTLOOK ?
This should work OK with any version.
the AOL site gives help on how to do this showing you the names of your
servers. It is IMAP mail. Hotmail is HTTP mail, and again the Hotmail site
has help on how to do this.
MVP - Mobile Devices
...Run time error 'Could not find output table ...
Looking for some advice.
I'm using VB6 with Access 2007.
Basically, I'm creating a table called user1_table within the code, then I
have an insert statement that stores data into this table. After the program
is done, it drops the table. When the program is run again, it creates the
table, and so forth.
Now, this program works fine the first time, and then it gives me the
Run-time error of '-2147217865(80040e37)' at the point of execution the
insert table query. BUt if i tell it to run from there (debug mode), then it
when the error occurs , I...Folder Size discrepancy between Outlook 2000 and 2003
We are running the latest version of Exchange and deliver two different
versions of Outlook to our employees. We use Citrix to deliver Outlook
2000 and have local installations of Outlook 2003. We also have a
quota system in place.
We are noticing that the two version calculate folder size differently.
We pinned it down to how it calculates the size of an attachment. In
one example we had a Word document that in 2000 was listed at 8Mb and
in 2003 as 6Mb. If we save the file from both versions we see the file
is listed as 6.15Mb by the operating systems.
It does always work out the same ...Not getting mail from one domain
We have an Exchange 2003 server, sp1, not using IMF. We are unable to
receive mail from a user from another company. (One company only)
We delete all messages that contain virus's, and block messages with some
attachments. I get all notifications when this occurs. I have had all ndr
forwarded to me. but I dont see his emails coming to us. We sent an email
to him and asked him to reply, and still we do not see the message. I had
him send to both my work address and home address, I recieved the message
from my home address, but not at work. I looked in the message tracker and ...Memory error when copying rows
I'm getting this error "Excel cannot complete this task with available
resources. Choose less data or close other applications."
when I try to copy more than around 120 rows.
Excel is XP, machine has 256mb ram. It does not matter how many columns
are non empty in the spreadsheet, I tried it on different files. I
tried copying more and more rows, at 100 rows available ram has 4mb
left, then I select 120 rows hit cntl-c and it will crash and give me
that error. Also I have unchecked all add-ins.
Does anyone have any idea? I have searched KB but only thing came up
was about name...Outlook 2003 Follow Up Flags.
I am running Outlook 2003 and everyone else in the office
is currently using Outlook 97. Whenever someone sends me
an e-mail with a follow-up flag attached and I forward
that e-mail I lose the follow-up flag. In Outlook 97 and
in Outlook 2002 this was never a problem. I would hit
forward and the follow up flag and all attachments would
stay as normal.
I have looked everywhere. Is there a setting or
something that I am missing to correct this? We use
follow-up flags extensively in our office. We really
need a fix for this.
...y-axis titles get cut off
I've been having this problem since I got my laptop, which came with th
trial version of Office 2003. When I make a graph in Excel, and I typ
in the title for the y-axis, and depending how long it is, the las
section of the title gets cut off. When I go to print preview, it look
fine, and when I go to print it, it prints out fine, but in th
spreasheet, the last part of the y-axis title gets cut off, and i
really annoys me. So, I thought it was just a problem with the tria
version, but yesterday, I bought a key for the full version, and i
still does it. Does anyone know why this happens, a...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...How do I get Outlook to refresh my inbox more frequently?
My old OE refreshed my inbox automatically, and this new version on my XP
isn't. Any tips on how to get it to refresh on it's own?
No way to answer until you provide your Outlook version, mail account type
and connection type.
wrote in message news:BD237E1D-7DBA-42D7-8978-645BA417C4D0@microsoft.com...
> My old OE refreshed my inbox automatically, and this new version on my XP
> isn't. Any tips on how to get it to refresh on it's own?
...Getting Rid of the Zero
Can anyone here tell me how I can get rid of the zero that is in front
of the decimal. Example: Make 0.50 look like .50???
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
On Tue, 30 Sep 2003 19:02:29 -0400, yethela
>Can anyone here tell me how I can get rid of the zero that is in front
>of the decimal. Example: Make 0.50 look like .50???
One method would be to use custom formatting. But since you ar...opening Excel and then closing it
I have a file that is passed to me in XLS format, but I would much prefer to
work with it in CSV. So I did this...
' open the downloaded file in Excel and copy it over to L in csv format
Workbooks("D00100001554_0.xls").ConflictResolution = xlLocalSessionChanges
Workbooks("D00100001554_0.xls").SaveAs "L:\Activity.csv", xlCSV
This works fine except it leaves Excel open in the background. The only
thing to do is fine it in Processes a...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...Recommendations Please: Software That Can Backup Outlook While It is Open/Running
As the subject says. There are lots of packages that will backup the pst,
etc. once Outloook is closed, but some products claim to do it while Outlook
is open. Any suggestions on products that actually do this and do it
properly? If the product can safely backup over the network to a server and
can do incremental/update backups throughout the day, I'd really like to
hear about it.
...Get ride of double spacing
For some reason I can't get rid of double spacing ONLY in the print envelopes AFTER I hit Save AS even with different
names. I have done a repair but the same thing happened and I don't know how to change Save As options. the body is
single and have it on No spacing the second block over. I have Student & Office 2007. Could some one please tell me what
Have a good day,
remove "nospam" in order to email me.
If I hit the envelopes BEFORE saving it is OK
On Sat, 12 Dec 2009 01:12:03 -0500, RScotti <email@example.com&g...