Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 4th 05, 03:44 AM
gxdata
 
Posts: n/a
Default Excel error - Startup (and Acrobat PDFMaker)

This must be such a common error, that I'm surprised it's not explicitly
"detected" by Excel on startup.

Error symptom:
Excel 2003 cannot open any vintage of .XLS file, and even on invoking Excel
alone, the same error message occurs - "This file is not in a recognizable
format.
* If you know the file is from another program, ...."
etc
[OK] [Cancel] [Help]
That's rather a cryptic error, and although it is very wordy and helpful, if
you know what's actually wrong, it could be much more informative.

Situation:
I had Office 2002 installed, and Adobe Acrobat 5.0 as well - the "full
version" which allows PDF file creation, editing, etc.
I knew that on upgrading to Office 2003, Adobe warned that the facility to
create PDF files from Word (or Excel, etc) was faulty / unsupported (or
something) with Acrobat 5.0. "Please upgrade to Acrobat 7"
So, I searched my system for all the PDFMaker DLLs, .DOT, .XLA, etc files
that were 2001-vintage (installed by Adobe Acrobat 5.0), and used WinZIP to
retain them in their current folders.
So, the file PDFMaker.xla which Office 2003 install had picked up from my
Office 2002 installed location and put into C:\Program Files\Microsoft
Office\OFFICE11\XLSTART\ was moved to a .ZIP file, but remained there.

Remedy:
Never leave anything but "normal" files that Excel understands in the
"Startup" folders.

If a PDF file is there, for instance, this error does not occur, and Excel
2003 will actually load a PDF file. But put any ZIP file into an Excel
startup folder, and the weird error message occurs and you start to wonder
about reinstalling Office 2003 / Excel 2003 all over again.

Of course, that's what I did - uninstalled then reinstalled Excel 2003. The
real remedy is to remove "foreign" files from the various XLSTART folders.

--
Ian Thomas
GeoSciSoft - Perth, Australia



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to re install Adobe Acrobat in Excel? The adobe Acrobat work. Execl error Excel Discussion (Misc queries) 1 March 17th 05 02:29 AM
excel edit Jiggie Excel Discussion (Misc queries) 4 January 29th 05 03:08 AM
Controling Acrobat PDFs YS Excel Discussion (Misc queries) 1 December 18th 04 10:47 AM
Acrobat Vulcan Setting up and Configuration of Excel 0 December 8th 04 11:09 PM
Viewing Excel spreadsheets Jimbola Excel Discussion (Misc queries) 1 November 28th 04 06:59 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017