Does anyone have any tips on opening an MSN local folder -- .msnpst -- with
I can open regular .pst files but Outlook won't recognize the .msnpst files
that MSN mail creates.
you need to add an account using the msn connector then try closing outlook
and replacing the new pst it creates with the old one by renaming the pst's.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: htt...Excel loads slow
We just recently upgraded to XP SP2 with Office XP SP3. Before, on 2000, our
users did not have a problem opening files from a certain directory. Now,
while in Excel, the click the open folder and it takes 30-45 seconds for them
to navigate to each folder in the directory. Any thoughts as to why XP is
slower when drilling down through the folders? Thanks.
Right-click on the My Computer icon on the Windows desktop,
left-click on Disconnect Network Drive, and disconnect any mapped
drives that are not currently available.
> We just recently upgraded to XP SP2 with Off...ADO.NET Failed to load msxmlsql.dll
ADO.NET Failed to load msxmlsql.dll
How to fix this error?
System.Data.SqlClient.SqlException: Failed to load msxmlsql.dll.
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
am i missing something that needs to be installed on sql server? is this a
client side ado.net issue?
The error you're getting here is echo'd back from the SQL Server 2005
instance you are trying to connect to - it's not a client side issue. The
OpenXML ...Cannot compose email in html format only plain text
I have some sort of html problem as I can't insert text
into any text boxes in explorer. I also can't highlight
text and in outlook I can't enter text into an email in
html format, however in plain text I can.
I have installed the new XP sp2 update, I have used the
detect and repair option in Outlook, I have tried running
explorer from another pc on the network on my pc all to
no avail. So I am guessing that it is a problem caused
externally of explorer and outlook.
And I have also ran a fully updated virus check.
Any help would be much appreciated as this is driving ...Missing Message Text
Yesterday, Windows Live Mail started doing something strange. I type the
message, then press "send." The first lines of the message somehow are
removed. The recipient sees only part of the message and only part of the
message shows up in my sent messages folder. The first part is just gone.
Seems to be only on messages that are replies. Any ideas on what the problem
is, or how to correct it, would be appreciated.
Never heard of this . . . . . are you on version 14.0.8089.0726?
Regardless, try a reinstallation.
"DeVere" <DeVere@discussions.microsoft...bmp files in Excel Hyperlinks open with wrong program
I have a list of tools in Excel, and I have used Excel's hyperlinking feature
to allow displaying a picture of the tool by clicking the link. They always
open with Paint, regardless of what I do in the "Folder Options >> File
Types" box. I have customized the .BMP file type by adding "Edit with Paint"
and "Edit with PhotoEditor" entries to the default settings. Does Excel look
for the entry actually labeled "Open" or does it just grab the first entry
from the list? (in this case, "Edit with Paint" is first, because they are
...Excel 2007 convert into tab delimeter text file with extra tab spa
Sub: I have excel 2007 trying to save as tab delimeted text file having an
I have saved my excel 2007 as separate Tab delimited Text files. I see extra
tabs stored in the tab delimited text files.
But when I do the same with excel 2003 it works fine there is not extra tabs
stored in my tab delimited text file.
My excel 2007 conveted to tab delimited text file looks like as shown
below(Extra two tabs at the end of the each record).
Appreciate your help in advance.
Rega...Word cannot complete the save due to a file permission error
One of my corporate users is experiencing an odd issue producing an error
message when attempting to save a Word 2007 document.
1. User has the pre-existing (not new) document open and clicks the save
2. In what seems to be a random occurrence, the document will bring up a
"Save As" dialog box asking him where to save, as if Word forgot where the
document is already saved! Odd thing is, it shows the proper location where
the file already exists.
3. User will choose the same location and replace the file. Sometimes it
will overwrite and save prope...Temporary Excel files.
does anyone know where Excel stores its temp files to managing
multiple opened copies of the same workbook?
Word stores its lock files in same directory of the opened document, but
Thanks in advance for the answers.
On a single user (non-networked pc), excel will put a few files in your windows
But I think it does more than just that. (Just guessing!) When the workbook is
on a network, excel/windows is smart enough to be able to tell that second
person the the file is in use.
If the only indicator were on the first user's temp file, then the seco...Outlook 2000, large pst file slow to open or corrupt
Hi, this is a very frustratring problem I hope someone canhelp us with. I've
established that the outlook.pst file is either too large of corrupt. I've
run scanpst which found no problem, the pst file is 2gb! should this cause a
I can't reduce the size of the file, although is will open, it won't let me
delete of move anything or even archive - reporting that it can;t access the
pst file although I can open it and browse contacts and messages (it's very
slow doing this though)
How can I reduce the size of this file in another way?
See if this info helps:
http:...Need several text box templates
Am making a catalog over 80 pages. I love this program.
My concern is with text boxes.
I have a general text box template that is used for each new page. Works fine.
But within that page is another text box or several that is filled in with
color for emphasis. Not used on all pages but is a "subcategory" text box.
Used as needed.
I need to change the color and realize there is no way to make an
acros-the-board-change. Or is there?
So the first question is:
1) Can I change the format (fill-in) text boxes that are inside a text box
all at once?
2) Can I make a template for a ...Outlook 2007 long delay when attaching a file
I have a long delay (about a minute) when attaching a file. Outlook freezes
for a minute before Browse for a file dialog appears.
Windows 7 x64
BitLocker is enabled
Domain joined computer
Outlook 2007 SP2
Outlook uses Exchange Server 2007
Do you have mapped drives? That will add a delay.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:firstname.lastname@example.org...Saving files as JPG
Often when I save a logo and/or a flyer in publisher and then save it as a
jpg for bi print jobs there is a LINE along the side of the piece ... any
ideas of how to get rid of it or WHAT might cause it?
This happens once in a while, never have figured out why. You can open the image
in Paint; erase the line. Or crop it out when you use the image in Publisher. Do
you get the line if you save the picture as a .png or .tif?
Mary Sauer MVP
"Greetings&Salutations" <Greetings&Salutations@discussions.microsoft.com> wrote
in messa...Merge file pairs
I have several hundreds of pairs of files (file1 in one subfolder i
paired to file1 in second subfolder) where I need to open the pair
copy arange (columns a to e) from one file to the other, then save an
close the files. Then loop on to the next pair in the list. Has anyon
done this? Can you point me to examples? I've looked at several we
sites (debruin, for ex.) but cannot find exactly what I need. Al
rroach's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2...Text cell complains about date
I have a column containing ratios like 3/4, 3/0, 5/2, etc.
I have them all formatted as text.
All of the cells that have a zero as the second number (3/0) get a
little green triangle and a warning that I have entered a "date string
with only 2 digits for the year".
How is "3/0" a date string with 2 digits for the year?
And, why is it complaining about a text field?
More importantly, how do I get Excel to stop being so "helpful" and
leave my damned text data alone -- unexamined?
Remove the warning in Options, Tools>Options>Error Checking in 2003...Comment: Default Text Size etc...
Can I change the default size of the comment, and the text within? I have
tried to play with each one but that is a pain in the butt. I have searched
for it to no avail.
Any assistance would be appreciated.
Try this (It's a setting in windows, not in Excel):
Right-click on any empty space in *windows desktop* > choose Properties
Select Appearance tab* > click "Item" dropdown menu > choose "Tooltip"
Choose a Font and Size to taste (You can also change the color here)
Click OK > Apply > OK
*If in WinXP, click "Advanced&qu...in Excel 2000 how do I convert text to numbers?
I imported files from Wells Fargo and I want to convert them from text to
numbers...so far nothing is working! thanks
Format all as General.
Copy an empty cell(also formatted as General).
Select range of numbers. Edit>Paste Special>Add>OK>Esc.
One other method.........
Select range of numbers and Data>Text to Columns>Finish
Gord Dibben Excel MVP
On Sun, 27 Feb 2005 11:53:06 -0800, Jo Dee <Jo Dee@discussions.microsoft.com>
>I imported files from Wells Fargo and I want to convert them from text to
>numbers...so far nothi...Can't find the file in Excel unless I open it from Excel
Can't find the file in Excel unless I open it from Excel
I have a stange problem that has just started. I am running Windows XP
and Office XP. If I click on an Excel file in my folders in explorer, it
will open Excel and an error message comes up telling me it can't find the
file and to check the path and folder.
Once I click out of the message the file sometimes is already open.
I have no problems if I open Excel first then open a file - it is
driving me crazy, please help.
Tr...Huge "empty" excel 97 file !!
I still have files of up to 4MB, after deleting the
contents of a 16MB excel 97 file then saving !!!
(1)If I select the whole worksheet (by clicking on the
blank cell in the top left corner of the worksheet)
(2)then I click on EDIT and then on DELETE.
(3)repeat 1&2 for any other sheets
(4)Then click on FILE, then SAVE AS a new name
Windows explorer shows that the new file can be up to 4MB.
This is very frustrating if I am trying to reduce the size
a file so that it fits onto a floppy disc.
This problem occurs with a number of my excel files.
How can I get rid of this invis...Password to open file
How do you make file only open after you enter a password?
dcknie, file save as, tools, general options enter password to open, this is
for excel 2003 its a little different in other versions but that should get
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"dcknie" <email@example.com> wrote in message
> How do you make file only...file
I have an excel file that an employee tried to save and
somehow has an error message on it that it will not save
because locked by another station. I have done everything
from trying to find out who last used it to deleting it
and starting over and nothing works.
Maybe Debra Dalgleish has the answer:
> I have an excel file that an employee tried to save and
> somehow has an error message on it that it will not save
> because locked by a...Extremely slow file
I've been doing some ad-hoc analysis at work today and as a quick fix (and
because I don't have the Access query skills) I ended up with 2 sheets:
Sheet 1 - Contains 21,000 rows of data, 10 columns with the first column
being a concatenation of 4 cells from each row
Sheets 2 - Contains 10,000 rows with 7 VLOOKUPs in each row, but each
vlookup is like the following:
Where the data_range is all 21,000 rows x 10 columnsrange in sheet2
Anyway, the file is simply too unwieldy to use. It takes an age to calculate
the cells, apply ...xls file won't open
I have an Excel file which I'm no longer able to open
as the system comes back with a message
saying 'Not enough memory'
The file size is 887kb, I think it was created in
Excel 2000 with Win98, but may have been on a
machine running XP Home when the problem occurred.
I am able to open much larger files without problems,
I have also tried opening it on several other machines
which have XP Home and Pro, obviously these have
newer versions of Excel.
Has anyone got any ideas how I can recover my
Any help will be appreciated, and thanks in advance
for any help yo...Import and Export files
I currently have Outlook 2002.
I brought a new computer and installed the new edition
of MS office and use outlook.
I exporting a file from the new version, and want to import
to my current work outlook 2002.
Is there any way to do this, and Outlook 2002 will not
reconize the newer version.
Any Ideas or help,
New version? which version?
"Gene" <firstname.lastname@example.org> wrote in message
> I currently have Outlook 2002.
> I brought a new computer and installed the new edition
> of MS office and u...Microsoft Word 2010 Beta doesnt recognise old word files immediate
I have just installed MS Word 2010 beta. Unfortunately, existing word
documents created in MS Word 2002 are not immediately recognised by MS 2010.
If I first open 2010 and go to file loaction the docs will open fine. However
, if i double click on a pre-existing word doc it does not know what
programme to use to open it.
I have tried finding the winword file to open it but get this message...
".doc is not a valid Win32 application"
Is there anyway to solve this issue as it is really inconvenient to have to
open Word 2010 each time and manually find the location of ...