We have an excell workbook that is linked to an extrenal SQL data source. The
preserve cell formatting box is checked on the External Data Range Properties
pop up.

Randomly we will get cells were the format is being changed. The data fields
that are being imported are text. The cell format is set to General and is
being switched to Text. When this happenes the cell display all #######. I
have been checking the data in the cells that this happens too for any odd
charicters. (line feeds, char returns....) I don't see anything that would
make this happen. It looks to be completly random.

Any insight would be a huge help.
Thanks Kevin

I don't use SQL, but if you change the format back to general, you should see
the text correctly.



Kevin wrote:

We have an excell workbook that is linked to an extrenal SQL data source. The
preserve cell formatting box is checked on the External Data Range Properties
pop up.

Randomly we will get cells were the format is being changed. The data fields
that are being imported are text. The cell format is set to General and is
being switched to Text. When this happenes the cell display all #######. I
have been checking the data in the cells that this happens too for any odd
charicters. (line feeds, char returns....) I don't see anything that would
make this happen. It looks to be completly random.

Any insight would be a huge help.
Thanks Kevin

--

Dave Peterson