Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 2007,Where is the Dialog box,the templates,with???? Bren Excel Discussion (Misc queries) 2 April 30th 07 12:52 AM
Lotus .wks file support Excel 2007 Alan Excel Discussion (Misc queries) 3 March 12th 07 07:52 PM
Does Excel 2007 support worksheet compare? Paul Huelskamp Excel Discussion (Misc queries) 2 February 5th 07 08:50 PM
excel 2007 tech support sammy Excel Discussion (Misc queries) 4 January 25th 07 03:24 PM
Support for Custom Xml Schemas in Excel 2007 Alan Excel Discussion (Misc queries) 0 December 22nd 06 05:40 PM


All times are GMT +1. The time now is 03:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"