Unable to Read File #2
I cut and paste another part of the file to an existing excel file,
When open the file again, the page is blank and a dialog box states:
"Unable to open file". I saved my work every step of the way. I made a
backup copy and have tried it several times. Each time the dialog box
states : Unable to read file. What is the problem?
Are you by any chance running XL97 or XL2K, and within the range that is
being cut and pasted have any references to names that use formulas such as
I would have expected it to crash Excel if you do, but worth asking the
qu...How do I open a .pub file without publisher?
David Bartosik - [MSFT MVP]
"Amelia" <Amelia@discussions.microsoft.com> wrote in message
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.776 / Virus Database: 523 - Release Date: 10/12/2004
Any one of the following options will work.
Get and install Publisher.
Send it to someone who will convert it to a pdf file. This assumes you have
Acrobat Reader, if no...import pst file #2
yet, another problem with importing a pst file:
When I have chosen the file to import I get the message:
'Properties for this information service must be defined
prior to use'
But I cannot find anywhere to define it when importing???
I obviously made a definition naming the pst file when
exporting it. But how do I import the file?
How did you create this PST file? Was it ever on a CD? If so, remove its
read only attribute.
"carsten" <email@example.com> wrote in message
news:firstname.lastname@example.org....File access error in Excel
I just started having a weird problem in Excel. I go to save a file that I
recently opened and updated, and I get an error message that access to the
file is denied for a file sharing error. If I save the file to another file
name, and then immediately "save as" back to the original name, it works
fine. I tried uninstalling and reloading Excel (a very laborious process
because I must uninstall and reinstall all of Office Pro, and then download
all updates since my CD copy). This seems to fix the problem for a while,
but it returns a few weeks later. I am baffl...Sync. question for .pst file.
If anyone can help, I would like to sync my .pst file from my office PC to
my laptop. Now I am using the sync program in Windows 2K and I get the
error that says this type of file is unable to be Synchronized.
I have done this before, I know you can go into the Registry and change what
types of files can and can't be Synchronized. Can anyone tell me where that
setting is. It's been a while since I had to do this and I completely
Thanks in advance for any help you can give me.
Running Win 2K and Office 2003.
...How to create Excel file?
I'm creating an application and I want to save the output in an excel sheet
file, doesn any one know how can I do that ??
What do you mean, do you want to save it in a format that Execl can read, or
do you want to save in a real execl file.
Execl doesn't have a problem reading comma seperated files, if that
Or look into actually opening an execl spreadsheet within your application
and let the user input their data directly into the spreadsheet. (COM
and here are links with descriptions to the file format
Is there any way to open Lotus 123 files in Excel?
As far as I know, yes. Open them.
"jasper" <email@example.com> wrote in message
> Is there any way to open Lotus 123 files in Excel?
File>Open>Files of Type>Lotus 123 *.wk?
Give it a try.
Gord Dibben MS Excel MVP
On Fri, 8 Feb 2008 19:01:00 -0800, jasper <firstname.lastname@example.org>
>Is there any way to open Lotus 123 files in Excel?
What version of excel and what extension of the Lotus file?
jaspe...How do I move current faulty pst to backup and set up a new pst?
Yesterday I had my laptop turn itself off, probably because of overheating.
When I started it again Outlook can read but not write to the outlook.pst
file. I've tried to run scanpst.exe but it freezes everything but the mouse
about 6% in to the first step scan and I have to cold boot the laptop. I've
tried copying outlook.pst to a different folder, a usb memory stick and via
LAN to another pc but no luck, the copy locks up and never finishes. I have
also run chkdsk several times and it recovered some misallocated sectors so
something did go wrong with the file system.
...Password protecting certain worksheets in a file
How do I set passwords to protect just certain worksheets
in a file?
If you mean worksheet passwords, one way:
Public Sub ProtectSomeButNotAll()
Const sPWORD As String = "drowwsap"
Dim vSheets As Variant
Dim i As Long
vSheets = Array("Sheet1", "Sheet3", "Sheet5")
For i = LBound(vSheets) To UBound(vSheets)
In article <email@example.com>,
"Mike" <firstname.lastname@example.org> wrote:...::: Excel
Will anyone know how many tabs one Excel file can include ?
Thanks for your input ... I will search on my side.
From Excel HELP:
Sheets in a workbook Limited by available memory (default is 3 sheets)
Microsoft MVP - Excel
<email@example.com> wrote in message news:firstname.lastname@example.org...
| Will anyone know how many tabs one Excel file can include ?
| Thanks for your input ... I will search on my side.
You don't say which version of Exce...Old pst file
I have an old pst file saved on cd that I need to get an email address from.
I no longer am on an exchange server. Is there a utility for viewing emails
in the pst file? Is there a utility that will import the pst file into
Outlook Express without having full Outlook on my system? Currently Outlook
Express keeps saying to configure the Outlook email client before import.
Thanks in advance for any help.
OE cannot use PST files.
The messages you are getting are correct. Believe them.
"Outlook Dummy" <email@example.com> wrote in message
news:...size of .pst file #2
I have attempted to find the answer to this question by searching this
group, but to no avail....
Until recently I was running Outlook 2003 with a single pst file.
However, given that it has reached 800MB, and since I wanted to split
the storage of personal and work emails, I decided to create 2
additional pst files ('personal' and 'work'). I did just that,
following which I moved the relevant folders from within my Inbox
structure to the two personal folders.
To my suprise the original .pst file did not change in size. I shut
down, restarted. I also tried to compact it, which...backup Outlook.pst file if busy
Some users leave their Outlook up overnight & our backup
can't pickup a busy outlook.pst file. Can I automatically
close Outlook say at 11:00pm before our backups run?
Doug <firstname.lastname@example.org> wrote:
> Some users leave their Outlook up overnight & our backup
> can't pickup a busy outlook.pst file. Can I automatically
> close Outlook say at 11:00pm before our backups run?
Some remote-control programs allow this.
...creation of bmp files
is there a method of creating bmp files by entering
(x,y) coordinates into a spreadsheet and then somehow
converting to a bmp file?
Are you hoping to create bmp files of charts?
"c vance" <email@example.com> wrote in message
> is there a method of creating bmp files by entering
> (x,y) coordinates into a spreadsheet and then somehow
> converting to a bmp file?
...why outlook1.pst and outlook.pst?
A friend's PC using Outlook 2003 has 2 .pst files - Outlook.pst and
Outlook1.pst in Documents and Settings\<his name>\Local
One is about 1/10 the size of the other and one starts with upper case
letter O and the other with lower case letter o. I cannot remember
which way round.
Why are there 2 .pst files?
Are both constantly updated? Maybe one is his archive PST file where old
data gets moved during the AutoArchive process. If not maybe he created one
by accident and it's just sitting there unused.
"...Outlook PST file empty.
I have 2 .pst files. When I view the file properties in
Explorer/File Manager etc they show as 4MB and 40MB in
When I open them through Outlook (2000, 2002 on NT and
XP) both files show as completely empty, and the file
size as 0KB.
I've run scanpst.exe, and it can't find any problems with
the files. Has anyone got any ideas?
See if any of the additional tips on the following page help:
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the n...recovering deleted files
Is there anyway to recover files that were REPLACED
during a restore backup. Windows 95 OS running Microsoft
Money 97. Please help someone. Tried everything I know
to do and my friend is frantic!! Thanks a lot. Lesa
Which file are you trying to restore? If it's a .MNY file, then Windows
wouldn;t replace this as there are no .MNY files in Windows that would
overwrite it. You've done a search of the system for this Money file?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send ...Importing excel files into access 97
I am trying to import excel files into an access 97
database however having gone through the file and import
menu the only options i have in the "Files of type"
dropdown menu are ms access and ODBC database files.
Excel etc are missing. I have tryed reinstalling the
whole of office pro 97 with no joy.
Can anyone help?
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
It sounds like the Excel and Text ISAM drivers are not registered properly.
If any ISAM drivers are not registered properly (mstext35.dll, msexcl35.dll)
you will need to registe...Exchange as file storage
I have a client who asked whether they can use their Exchange Account
(Outlook Anywhere) as a way to storage some files. They are planning on
doing that basically via files attached to emails and also to notes in
Now, I know this is generally not a good idea and I know the general
Exchange storage limits. But I am trying to quantify it all a little bit. Of
course it is ok to have say 25 MB worth of emails and attachments in an
Exchange account. And of course, a mailbox size of say 3GB is not OK.
So somewhere in between is a limit and I am trying to find out what that is.
It m...Multiple Database Files
I am currently taking a class on MS SQL 2000. We
currently have Great Plains 7.5 running on MS SQL 2000.
The recommendation from class is to create multiple
database files to increase performance, example:
compdatabase.mdf,compdatabase.ndf. Is this supported by
Great Plains? My concern is that if I set this up to
increase performance when I request support from Great
Plains, Great Plains will not support me because my
company database is split into multiple files. Is anyone
running a company database that is split into multiple
Thanks for any advice you can p...pst
I know PSTs over a LAN aren't supported, and are a crappy idea but they used
to work fine with the Novell server used in exactly the same way. Since
migrating it to windows server 2003 we;re getting problems with people being
able to open them. They work for a bit and then stop.
I'm assuming it's some network configuration that needs to be changed on the
server. But does anyone have any idea what?
I am sure you have seen
http://www.swinc.com/resources/exchange/faq_db.asp?status=questions&faqID=1000&faqname=Exchange%205.5§ionID=1013§...opening .csv file
Hi, I have problem with opening csv file. (W XP, Excel 2003+sp1) I want to
open file automatically without "import". Delimiter in file is comma. In
excel - tools - posibilities have I set "not used delimiters from system" ...
I have excel 97 too and there it works. Thanks for advice...
...Outlook 2003 Locked-up on receiving files
Using Outlook 2003 on Windows XP
All updates are applied!
my PST file is only 65 MB
I repaired Office, I'm using a brand new machine, 1 GB RAM, very fast
Just out of curosity I went to Intrenet access of my mail and it was fine.
I open Outlook and it hangs on receiving email. There is two emails from
family members that
also keep replicating in outlook when I first open it and Outlook starts to
receive emails. Thats when it locks-up.
There is a outlook task icon on the bottom right
that when I put my mouse over it says "Microsoft Office is Synchronizing
...PST file over 2GB and corrupted
When running the PST crop tool from MS to crop some data from an oversize
PST file, from what portion of the file does it delete data? Start (old
stuff?), middle, or end of file (new stuff?)?
There is no real way to determine what content will be cut. Take a backup,
run the pst2gb utility and assess the result in Outlook.
"Gregg Hill" <firstname.lastname@example.org> wrote in message
> When running the PST crop tool from MS to crop some data from an oversize
> PST file, from what portion of t...In VBA, check if file is corrupt or not Excel
I'm using Excel 2003.
Using VBA, I am looping through a number of excel files, extracting data
from each, and writing that data into another excel spreadsheet.
Occasionally, there is a Word document in the directory, and once there was
a corrupt Excel spreadsheet.
How do I check if the excel file that I'm trying to open is corrupt or not
in an Excel format?
Your help would be greatly appreciated!
You can loop through only the excel files and if it can't open the file skip it
Regards Ron ...