Format Cells Date (or any change) not working on imported data
I've just spent ages researching this and not come up with what I need
to be able to do.
I have a worksheet for some simple data that has been imported, a
date, text and number column (as they display graphically to the end
user). All are a "general" format when using Format > Cells.
The issue I have is that the date information is in an American date
format and I would like to change them into a UK date format. Format >
Cells and selecting any option (including custom and special) makes no
changes to the imported data.
I have seen the work arounds whereby you sp...Windows 7 Home Premium (64 bit) Won't Recognize Outlook XP .pst Fi
I received an insightful answer to my previous post on receiving "cyclic
redundancy" errors when opening Outlook XP .pst files with Outlook-2007 on
Windows 7 Home Premium Edition. I've used chkdsk as suggested, and am no
longer receiving this error. Instead, I am receiving a new error report of,
"Windows does not recognize Tools.pst as a valid 32 bit application'.
Can anyone suggest a fix for this?
How are you trying to open it?
To reconnect a pst-file in Outlook use;
File-> Open-> Outlook Data File...
Note that this is no...Outlook Mobile Access Problem
Hi I've a big problem in Outlook Mobile Access.
I've a server exchange standalone withoput a front-end=20
I've configured the OWA web form authentication and SSL.
For OWA it's all right...everything is going right...
The problem is OMA
When I try to log on on oma I find the following error=20
message :"Unable to connect to your mailbox"
To solve my problem I've found in microsoft web site the=20
Microsoft Knowledge Base - 817379
Cannot Access Exchange Server 2003 by Using Outlook Mobile=20
Access When the
Exchange Virtual Directory Require...Linking a graph to a csv file
Hello, I'm sure this is exceedingly easy, but somehow,
I'm screwing this up. I ultimately need to have a self-
updating PowerPoint file (client mandates a ppt file).
According to ppt's help, that means I have to use linked
Excel graphs, not embedded ppt graphs. However, my
programmer will be supplying me with tons of csv files.
When I try to create an excel file with a data link to a
csv file, it tells me that it can't update it unless I
open the source file. I *can't* take the time to open
each csv - there will be hundreds. What am I missing
wi...outlook 2007 runs slow
Outlook 2007 runs slow. Is there a way to speed it up.
Do you have the outlook performance update installed?
Are you using a Dell laptop?
Did you upgrade from an older version and are still using that profile?
http://www.slipstick.com/outlook/ol2007/slow.htm - install the update
listed at the end - also make sure all OS and Office updates available
through Microsoft update are installed. If it's still slow, try the various
solutions that apply to your situation.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Ta...How do i get outlook to update hotmail account without reopening?
the tedster <the email@example.com> wrote:
Ask your question in the body of the message.
Without reopening what? Outlook? Hotmail? The short answer is "you
...can't send anything in Outlook 2002
I just sent a post asking for help because I can no
longer send email with attachments. After sending in the
post, I went back to Outlook and clicked on the
Send/Receive button just to check if I had any new mail.
I got the same message: "The operation failed". So I am
totally out of business with Outlook. How to solve the
Did it work before? Did you change anything in yr settings? Are you sure
your internet mail account settings are valid (correct username, pw,
"Marilyn Fogelquist" <fogel@cablespeed........Quirky recent file list #2
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
If/when you upgr...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...Check Printing #6
I get the error " no accounts with checks to be printed"
I used the salvage utility from microsoft and that didn't
seen to help, any suggestions? Thanks in advance
Did you use msmoney -s (which is different than salv.exe)?
"Kris" <firstname.lastname@example.org> wrote in message
> I get the error " no accounts with checks to be printed"
> I used the salvage utility from microsoft and that didn't
> seen to help, any suggestions? Thanks in advance
...outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...allowing or disallowing changing the state of check box
what's the best moment to check if the user has right to change the state of
check box and then to allow it or cancel it. I've tried with "before update"
event procedure. It seems to work but after, when I press anything else on
the form event procedure is repeating?
The problem occurs (repeating) when Cancel = True was applied previosly.
> what's the best moment to check if the user has right to change the state of
> check box and then to allow it or cancel it. I'...How to do a mass download of names to Outlook address book
I have about 800 names and email addresses in an Excel
spreadsheet that I need to add to my Outlook address book.
Can anyone give me a hint on how to do this?
Save the Excel Spreadsheet as a CSV (Comma Separated Value) file and then in
the Address Box, Click, File, Import, Other Address Box, then click Text CSV
file and browse to it.
"Hal Segal" <email@example.com> wrote in message
> I have about 800 names and email addresses in an Excel
> spreadsheet that I need to add to my Outlook address book.
> C...graphing data
What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?
Graph them in exactly the same way that would have done if the numbers had
been typed into the cells.
"mikaman" <firstname.lastname@example.org> wrote in message
> What is necessary to graph the number(s) in cell(s) when the number in
> cell(s) is/are generated from a formula in those cells?
...Copy filtered data
Let's say I have data in A1:Gxx. Now I use Autofilter to find all rows which has a "2" in column C. Let's say it leaves rows 1:4 and
8:10. Now I want to copy the filtered data in columns F:G and paste the values (not to an empty range which is easy) but to the same
cells in colums D:E.
Try Advanced Filter, excellent tutorial here from Debra Dalgeish, owner of
"Hans Knudsen" <Hans.Knudsen@mail.tele.dk> wrote in message
news:%23xtVdlR8FHA.740@TK2MSFTNG...MSN accounts dosen't work in Outlook.
I can't download my e-mails from MSN to Microsoft Outlook 2003.
I have setup the account correspondent to Microsoft Outlook 2003 Wizard, but
it still dosen't work.
Does anyone know where the problem can be?
Only the paid MSN and Hotmail accounts will work in Outlook and/or Outlook
Express. Are you supscribed to the paid service?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"hardharut" <email@example.com> wrote in me...Outlook 2003
I copied my PST file from my D: drive to my F: drive.
I then went into "Data File Management" to get the new location
recognized and to have all future mail sent to that location.
After doing this, my custom settings, like new folders, date
settings, columns, etc, are all back to their default settings.
Is there any way I can get my custom settings working again on the F:
Could you explain yourself a bit more? What custom settings are you refering
to? You mean views? And what new folder settings?
Also post your version of Outlook.
Robert Spar...Import Palm files
Can anyone help me by telling me how to import palm files
(dat files) into outlook. I want to import contact,
Depends what you can export to from Palm Desktop. Personally, I've found
this messy. Why not just get sync software that can sync your Palm with
Outlook directly? Chapura Pocketmirror or Pumatech Intellisync are two
ideas....or your Palm CD may have come with this option.
F. Carvalho wrote:
> Can anyone help me by telling me how to import palm files
> (dat files) into outlook. I want to import contact,
> calendar, etc
...Outgoing emails not sending for outlook express 2000
Can anyone help me?Everytime I try to send an email these
error messages pop up and I have no idea what to do;
The host 'SMTP' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'SMTP', Protocol: SMTP, Port: 25, Secure(SSL): No,
Socket Error: 11001, Error Number: 0x800CCC0D
The host 'POP3' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'POP3', Protocol: POP3, Port: 110, Secure(SSL):
No, Socket Error: 11001, Err...copying data
Getting errors when copying data from workbook to workbook. Shutdown and
restart allows without errors.
...New Check report security settings
I'm using Report Writer in GP v10. I want to duplicate the report "Check
with Stub on Top and Bottom - Graphical". I have tried to use the duplicate
button for the report but the report will not show up in the User Security
How can I make the duplicated report available to select users?
I would suspect you do not want to duplicate this report (since you cannot
really run it correctly) and instead you modify the actual report by
choosing the report and pressing "insert". You give security to the
modified version once you've modifie...Excel to check for regular expression?
How do you use Regular expression in excel? For eg: Check a column of
data to see whether are all of them valid email addresses?
By valid, do you mean that the email is in proper syntax or that it is an
actual email address.
Text formulas can be used for proper syntax. Perhaps a Visual Basic
I doubt you can check that the email address actually exists, as many
companies and ISPs will simply disregard and drop mail to invalid email
addresses to eliminate spam
> How do you use Regular expression ...Outlook 2003 Contact data
Just starting using Outlook 2003.
When composing an email, when go to address the note, it appears that there
are 2 Contact files - 1 is "blank" and the other has lots of my contacts.
It is the latter contact file that I enabled to use as my address book.
Initially address book comes up the first one and I get error message. Then
I toggle to the second one and all the names are accessible.
How do I get rid of the one that appears blank, so only one contact file
appears when I go to address an email?
Les <firstname.lastname@example.org> wrote:
> When composing an e...List Shows Private Files
DID ANYONE ELSE NOTICE THIS?
Whenever I save an attachment, and go to the drop down
menu for file name, I am shown a list of dozens of files
recently accessed on the computer (not just files
accessed by Outlook Express). This occurs even if recent
cocuments is turned off in Windows XP and even if the
recent documents folder for Windows XP has been cleared.
This shows too much! Others using Outlook Express on the
same computer can potentially view the file names of
every document, image, and device recently accessed.
Where is the folder to clear this data out of?