Excel 97 cannot open long filenames

Weird glitch when upgrading Win 98 machine to XPPro - Excel will now not
open any file name with 27 characters (not including the '.xls suffix') or
longer. The error message asks to check file location & spelling. If
filename is shortened to 26 characters or less - opens fine.

However, after a Excel 97 reinstall, a long file name opened (1st file
opened) but excel returned an error along the lines of 'you cannot open more
than 1 file with the same name at a time' & on trying to open another long
file name, the same error as above.

These 'long files' open okay across the network with another XP Pro/Excel 97
machine.

Anybody offer any help?

Fec

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel (both instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

fec wrote:

Weird glitch when upgrading Win 98 machine to XPPro - Excel will now not
open any file name with 27 characters (not including the '.xls suffix') or
longer. The error message asks to check file location & spelling. If
filename is shortened to 26 characters or less - opens fine.

However, after a Excel 97 reinstall, a long file name opened (1st file
opened) but excel returned an error along the lines of 'you cannot open more
than 1 file with the same name at a time' & on trying to open another long
file name, the same error as above.

These 'long files' open okay across the network with another XP Pro/Excel 97
machine.

Anybody offer any help?

Fec

--

Dave Peterson

Thanks but found that earlier on a website Dave & it doesn't work. I have
upgraded to excel on Office 2003 but still the same problem :-( The same
(long file named) file can be opened on another pc across the network and
can even be opened by word on the same pc with the problem??

Total mystery - any other hints?

Fec
"Dave Peterson" wrote in message
...
Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel (both instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

fec wrote:

Weird glitch when upgrading Win 98 machine to XPPro - Excel will now not
open any file name with 27 characters (not including the '.xls suffix')
or
longer. The error message asks to check file location & spelling. If
filename is shortened to 26 characters or less - opens fine.

However, after a Excel 97 reinstall, a long file name opened (1st file
opened) but excel returned an error along the lines of 'you cannot open
more
than 1 file with the same name at a time' & on trying to open another
long
file name, the same error as above.

These 'long files' open okay across the network with another XP Pro/Excel
97
machine.

Anybody offer any help?

Fec

--

Dave Peterson

No, sorry.

fec wrote:

Thanks but found that earlier on a website Dave & it doesn't work. I have
upgraded to excel on Office 2003 but still the same problem :-( The same
(long file named) file can be opened on another pc across the network and
can even be opened by word on the same pc with the problem??

Total mystery - any other hints?

Fec
"Dave Peterson" wrote in message
...
Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel (both instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

fec wrote:

Weird glitch when upgrading Win 98 machine to XPPro - Excel will now not
open any file name with 27 characters (not including the '.xls suffix')
or
longer. The error message asks to check file location & spelling. If
filename is shortened to 26 characters or less - opens fine.

However, after a Excel 97 reinstall, a long file name opened (1st file
opened) but excel returned an error along the lines of 'you cannot open
more
than 1 file with the same name at a time' & on trying to open another
long
file name, the same error as above.

These 'long files' open okay across the network with another XP Pro/Excel
97
machine.

Anybody offer any help?

Fec

--

Dave Peterson


--

Dave Peterson

fec

Shot in the dark...........verrryyy darkg

There is a 256 character limit on path names in Windows.

Perhaps you are exceeding that by a few characters?

As in--your user name is longer than others' names?

Gord Dibben Excel MVP

On Wed, 27 Oct 2004 10:43:19 +0000 (UTC), "fec" wrote:

Thanks but found that earlier on a website Dave & it doesn't work. I have
upgraded to excel on Office 2003 but still the same problem :-( The same
(long file named) file can be opened on another pc across the network and
can even be opened by word on the same pc with the problem??

Total mystery - any other hints?

Fec
"Dave Peterson" wrote in message
...
Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel (both instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

fec wrote:

Weird glitch when upgrading Win 98 machine to XPPro - Excel will now not
open any file name with 27 characters (not including the '.xls suffix')
or
longer. The error message asks to check file location & spelling. If
filename is shortened to 26 characters or less - opens fine.

However, after a Excel 97 reinstall, a long file name opened (1st file
opened) but excel returned an error along the lines of 'you cannot open
more
than 1 file with the same name at a time' & on trying to open another
long
file name, the same error as above.

These 'long files' open okay across the network with another XP Pro/Excel
97
machine.

Anybody offer any help?

Fec

--

Dave Peterson

fec

Thanks for the feedback.

I was thinking that perhaps the 256 limit was being exceeded in one case and
not in others because a username(not filename) in the path was longer than
other usernames.

As in C:\Documents and Settings\username\rest of path\ where username is
"usernamelongerthanothers"

Glad you're in business.

Gord

On Thu, 28 Oct 2004 09:58:01 +0100, "fec" wrote:

You were right - but it wasn't the file name that was too long, but the
entire name (back to the root folder) including all sub-folders was over the
256 limit.

Shortened the folder names & it worked.

Only curious thing is why Word would open the files?

Cheers

Fec

"Gord Dibben" gorddibbATshawDOTca wrote in message
.. .
fec

Shot in the dark...........verrryyy darkg

There is a 256 character limit on path names in Windows.

Perhaps you are exceeding that by a few characters?

As in--your user name is longer than others' names?

Gord Dibben Excel MVP

On Wed, 27 Oct 2004 10:43:19 +0000 (UTC), "fec" wrote:

Thanks but found that earlier on a website Dave & it doesn't work. I have
upgraded to excel on Office 2003 but still the same problem :-( The same
(long file named) file can be opened on another pc across the network and
can even be opened by word on the same pc with the problem??

Total mystery - any other hints?

Fec
"Dave Peterson" wrote in message
...
Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel (both instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to
excel's
factory defaults.

fec wrote:

Weird glitch when upgrading Win 98 machine to XPPro - Excel will now
not
open any file name with 27 characters (not including the '.xls suffix')
or
longer. The error message asks to check file location & spelling. If
filename is shortened to 26 characters or less - opens fine.

However, after a Excel 97 reinstall, a long file name opened (1st file
opened) but excel returned an error along the lines of 'you cannot open
more
than 1 file with the same name at a time' & on trying to open another
long
file name, the same error as above.

These 'long files' open okay across the network with another XP
Pro/Excel
97
machine.

Anybody offer any help?

Fec

--

Dave Peterson