ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel-2007 does not support Charts in Dialog Sheets (https://www.excelbanter.com/excel-discussion-misc-queries/143806-excel-2007-does-not-support-charts-dialog-sheets.html)

Smith

Excel-2007 does not support Charts in Dialog Sheets
 
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

Excel-2007 does not support Charts in Dialog Sheets
 
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
DTHIS
web:
www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"Smith" wrote in message
...
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



Jon Peltier

Excel-2007 does not support Charts in Dialog Sheets
 
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.a...stePicture.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Smith" wrote in message
...
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





All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com