Shrinking Graphs in Excel 2007
in [Charts]
|
Prev: how to make grand total to show up on pivotchart?
Next: How can I customise colours used in charts and keep those colours.
From: seanpottinger on 5 May 2010 05:48 We have a particular issue with some spreadsheets and shrinking graphs on each 'save as'. As they have older VB code, we can't 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
From: trip_to_tokyo on 5 May 2010 06:49 Sean, there have been other postings on shrinking graphs (you can see for yourself in the Search facility). I wouldn't hold your breath for a hotfix. "seanpottinger" wrote: > We have a particular issue with some spreadsheets and shrinking graphs on > each 'save as'. As they have older VB code, we can't 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
From: seanpottinger on 5 May 2010 07:54 Apologies, but I've been searching for shrinking charts and graphs and can't find anything? Can someone please post me a link? many thanks "trip_to_tokyo" wrote: > Sean, there have been other postings on shrinking graphs (you can see for > yourself in the Search facility). > > I wouldn't hold your breath for a hotfix. > > > "seanpottinger" wrote: > > > We have a particular issue with some spreadsheets and shrinking graphs on > > each 'save as'. As they have older VB code, we can't 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
From: Jon Peltier on 5 May 2010 22:47 "As they have older VB code, we can't 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 can't 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
From: Jon Peltier on 5 May 2010 22:49
As Trip to Tokyo hints, there are scads of questions and complaints about 2007 charts resizing. Search all you want, but you'll find no answers and no hotfixes. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 5/5/2010 7:54 AM, seanpottinger wrote: > Apologies, but I've been searching for shrinking charts and graphs and can't > find anything? Can someone please post me a link? > > many thanks > > "trip_to_tokyo" wrote: > >> Sean, there have been other postings on shrinking graphs (you can see for >> yourself in the Search facility). >> >> I wouldn't hold your breath for a hotfix. >> >> >> "seanpottinger" wrote: >> >>> We have a particular issue with some spreadsheets and shrinking graphs on >>> each 'save as'. As they have older VB code, we can't 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 |