Workbook has no bound sheets

[Terry Stedl]

When opening a workbook that has approximately 5000 cells linked to another workbook Excel notes that the workbook has automatic links to another workbook and prompts y or n to update linked information. When y is selected a Microsoft Excel message is returned "Workbook has no bound sheets" with ok as the only option. The next message is "Execl.exe has gernerated errors and will be closed by Windows. You will need to restart the program. An error log is being created." with cancel the only option. When cancel is selected the the same message with ok as the option appears. When ok is selected the program closes.
The linked workbook is created as a file written from a program called Plant Partner which is Excel version 5. I am using Excel 2000. There is no problem if I open the linked file first. Is there anyway not to have to open the linked file. Sorry if this is too wordy. This is my first try at a message board.

 

[George J]

I'm afraid i don't know of a way around this, i read about a similar problem and theresult was "the problem was that VFP was saving the auxiliary books in v5.0, and the master is in v97."

If you can save the file as v97 or other, this may fix it.

good luck

 

[Terry Stedl]

I'm afraid i don't know of a way around this, i read about a similar problem and theresult was "the problem was that VFP was saving the auxiliary books in v5.0, and the master is in v97."

If you can save the file as v97 or other, this may fix it.

good luck

Thanks for your help