A
Alex MacG
Whilst using Excel (one instance of application open) and several workbooks
with inter sheet data links and graphing I have problems with graph plot's
size changing by themselves and movement of text boxes around the plot area.
Realising this is a severe and probably old problem with Excel I have fixed
font sizes to a common size/font (8 point) and disabled chart autofont
resizing.
However,every time I do a change to VBA code or increase data/cell useage I
find that I need to try and code fixes for the chart variations (area/plot
sizes and positions) but I am now at a stage that these fixes through code
seem to have no effect. I guess I have reached the Excel limits somewhere?
Last major change was to add an XLA for labelling within a column and code
plot are fixes would then only work if the proc was called from a worksheet
command rather than from other procs in code although the code apparently ran
without hitch!!
Is there any way I can find where in particular the cause of the problem is
located or any method to optimise the workbooks/sheets or code. Would linking
data from VBA workbooks as objects in code be better than opening as
workbooks? I'm using Excel '97 but have tried on 2003 with no improvement.
I've seen the limits of Excel posted on Tek-Tips forum by "Grayshades" (in
Thread707-852619) and do not think I exceed those mention but could it be a
cumulative effect?
ANY ideas welcomed
with inter sheet data links and graphing I have problems with graph plot's
size changing by themselves and movement of text boxes around the plot area.
Realising this is a severe and probably old problem with Excel I have fixed
font sizes to a common size/font (8 point) and disabled chart autofont
resizing.
However,every time I do a change to VBA code or increase data/cell useage I
find that I need to try and code fixes for the chart variations (area/plot
sizes and positions) but I am now at a stage that these fixes through code
seem to have no effect. I guess I have reached the Excel limits somewhere?
Last major change was to add an XLA for labelling within a column and code
plot are fixes would then only work if the proc was called from a worksheet
command rather than from other procs in code although the code apparently ran
without hitch!!
Is there any way I can find where in particular the cause of the problem is
located or any method to optimise the workbooks/sheets or code. Would linking
data from VBA workbooks as objects in code be better than opening as
workbooks? I'm using Excel '97 but have tried on 2003 with no improvement.
I've seen the limits of Excel posted on Tek-Tips forum by "Grayshades" (in
Thread707-852619) and do not think I exceed those mention but could it be a
cumulative effect?
ANY ideas welcomed