File Error when opening workbook

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Ian Wakeling
Posts: 7
Joined: Thu Apr 07, 2005 10:23 am
Location: Norfolk, UK

File Error when opening workbook

Post by Ian Wakeling »

I am using version 3.01.02 to open a workbook, add data and cell formulae, and then to save it under a different file name. Despite the indication in the version history area that the problem has been fixed, I am still getting the "File Error, some data may have been lost" message when I try to open some of these files in Excel 2002.

The problem may, or may not occur, depending on the first workbook opened. When it does happen, I can make the problem go away by not assigning a password to protect the workbook.

Unfortunately it is important that I have a password, so is it possible to fix this somehow.

Ian.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post by larsa »

Hello

This error message is related to invalid cell formatting, such as assigning a border around a cell without setting the border color. Please check this.


Lars Arvidsson
Post Reply