Excel-2007 does not support Charts in Dialog Sheets

[Guest]

To open Excel-2003 file which including some Charts in Dialog Sheet by
Excel-2007, the system was not allowed and error show

"A dialog sheet in this workbook contains one or more charts. Because the
current version of Excel does not support charts in dialog sheets, all charts
will be deleted."

How can I solve this problem?

Thankyou
Smith

 

[Nick Hodge]

You have few options but not to open in XL2007. Dialog sheets were
deprecated in V95 (although they are still supported in the main)

This is because the charts in XL have changed significantly and are now
Office Art

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[Jon Peltier]

Convert from ancient dialog sheet technology to old user form technology
with either of these approaches:

http://www.j-walk.com/ss/excel/tips/tip66.htm
http://oaltd.co.uk/DLCount/DLCount.asp?file=PastePicture.zip

- Jon