View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default Shrinking Graphs in Excel 2007

"As they have older VB code, we cant save it under excel 2007 format"

What do you mean "older" VBA code? 2007 has the same VBA, with a few
more keywords. You could save under the 2007 format, xlsx if the
workbook being saved contains no code, xlsm if it does.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/5/2010 5:48 AM, seanpottinger wrote:
We have a particular issue with some spreadsheets and shrinking graphs on
each 'save as'. As they have older VB code, we cant save it under excel 2007
format and need to always save under 97-2003 format. This issue only started
occuring in the last month or so. It occurs on all PC's and for all sheets.
Is anybody aware of this issue or know if a hotfix is coming out?

Many thanks