Cannot open long file names

[fec]

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

 

[Nick Hodge]

Fec

You could try two things

1) Tools>Options>General>Ignore other applications>unchecked
2) In Windows. Start>Run... [Drive]:\[Path]\Excel.exe /regserver

the second will reset Excel's file associations

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)