What does "Workbook has no bound sheets" mean?
 

I'm working with spreadsheets in Excel 2000, and keep getting the message
"Workbook has no bound sheets", and then get promptly thrown out of Excel.

Any idea why I keep getting this message, and how I can stop getting it?

What does "Workbook has no bound sheets" mean?
 

I got this error in Excel today, 11jan06. I developed a spreadsheet in
Excel 2003 under WinXP and created a Name that referred to a range in
an external file, another Excel spreadsheet.

I update the 'other' spreadsheet from an accounting application (which
exports its data in .XL5, yes 'five', format). I simply renamed the
exported file extension from .XL5 to .xls and went on my merry way,
assuming my named link would work. That's when I started getting the
error.

After lots of frustrating attempts to figure this out, I simply opened
the 'other' file in Excel and saved it back on itself in 'Microsoft
Office Excel Workbook (*.xls)' format. The 'no bound sheets' error has
gone away.

I hope this helps someone else out there...


--
jeffo25
------------------------------------------------------------------------
jeffo25's Profile: http://www.excelforum.com/member.php...o&userid=30390
View this thread: http://www.excelforum.com/showthread...hreadid=354583