Why "data may be lost"

WYTT · May 7th, 2002, 09:25 AM

I have a big Excel file (350 KB), it is read-only, currently every time when i open the file, a window "data may be lost" always come up, why it happens? How can solve it? Thanks

Iain Lewis · May 7th, 2002, 09:28 AM

A couple of thimgs to check on :

Are there any auto run macros with the workbook ?

Do you have a cells that contains large amounts of text ?

WYTT · May 7th, 2002, 09:57 AM

No Macro. But have a lot of formulars

Iain Lewis · May 7th, 2002, 10:16 AM

Off the top of my head I can't think of anything else that could cause this. It may be that a cell / some cells have too much text in ( though I've only seen this when trying to "do" something to the cell ( eg spell check ).

Send me a copy of the file if you want - I may get inspiration over night.

zacemmel · May 7th, 2002, 10:36 AM

Check Q139132 at http://mssupport.microsoft.com

Jack in the UK · May 7th, 2002, 11:41 AM

try open excel file and save as new name.

close excel and open the new file..

fixed?

May 7th, 2002, 11:41 AM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	try open excel file and save as new name. close excel and open the new file.. fixed? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 09:25 AM	#1
WYTT New Member Join Date: Mar 2002 Posts: 13	I have a big Excel file (350 KB), it is read-only, currently every time when i open the file, a window "data may be lost" always come up, why it happens? How can solve it? Thanks

May 7th, 2002, 09:28 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	A couple of thimgs to check on : Are there any auto run macros with the workbook ? Do you have a cells that contains large amounts of text ?

May 7th, 2002, 09:57 AM	#3
WYTT New Member Join Date: Mar 2002 Posts: 13	No Macro. But have a lot of formulars

May 7th, 2002, 10:16 AM	#4
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Off the top of my head I can't think of anything else that could cause this. It may be that a cell / some cells have too much text in ( though I've only seen this when trying to "do" something to the cell ( eg spell check ). Send me a copy of the file if you want - I may get inspiration over night.

May 7th, 2002, 10:36 AM	#5
zacemmel Board Regular Join Date: Apr 2002 Location: Redmond, WA Posts: 636	Check Q139132 at http://mssupport.microsoft.com