Shapes on 2007 Spreadsheets
 

Is there some problem with having shapes on spreadsheets in Excel 2007?

I have a bank reconciliation program that matches book entries with bank
deposits. Both book and bank data comes in electronically, and I use macros
to match the entries. In many cases there are multiple book entries that
total to one bank deposit. The macro groups these multiple book entries,
draws a box (borders) around them, and then draws an arrowline (shape) from
the boxed group to the corresponding bank deposit. There are anywhere from
$200-300M dollars in deposits each month, so the spreadsheet is quite large.
In Excel 2003 it could easily take an hour to run.

In Excel 2007 this same process takes anywhere from 10-12 hours to run. It
appears to have something to do with the shapes, because if I go into in the
spreadsheet after it has been created, and page scroll from/to a page with a
lot of the arrowlines on it, you can literally count the rows on the screen
as it refreshes. If I page scroll from/to a page with no shapes on it, it is
fairly instant. Or if I look at a worksheet with no shapes on it, the page
scroll is also regular speed.

My assumption is that as the macro is creating the shapes at the appropriate
places, it is somehow slowing down the processing, but that is only an
assumption. But I have no other clues. I do have Screenupdating turned off
during processing.

Any ideas?
--
Bill @ UAMS

Shapes on 2007 Spreadsheets
 

One other thing - if I print the worksheet, the arrowlines (shapes) do not
print in the correct position on the printed page, even tho they show up in
the correct positions on the displayed worksheet. Excel 2003 printed
correctly.

--
Bill @ UAMS


"BillCPA" wrote:

Is there some problem with having shapes on spreadsheets in Excel 2007?

I have a bank reconciliation program that matches book entries with bank
deposits. Both book and bank data comes in electronically, and I use macros
to match the entries. In many cases there are multiple book entries that
total to one bank deposit. The macro groups these multiple book entries,
draws a box (borders) around them, and then draws an arrowline (shape) from
the boxed group to the corresponding bank deposit. There are anywhere from
$200-300M dollars in deposits each month, so the spreadsheet is quite large.
In Excel 2003 it could easily take an hour to run.

In Excel 2007 this same process takes anywhere from 10-12 hours to run. It
appears to have something to do with the shapes, because if I go into in the
spreadsheet after it has been created, and page scroll from/to a page with a
lot of the arrowlines on it, you can literally count the rows on the screen
as it refreshes. If I page scroll from/to a page with no shapes on it, it is
fairly instant. Or if I look at a worksheet with no shapes on it, the page
scroll is also regular speed.

My assumption is that as the macro is creating the shapes at the appropriate
places, it is somehow slowing down the processing, but that is only an
assumption. But I have no other clues. I do have Screenupdating turned off
during processing.

Any ideas?
--
Bill @ UAMS

Shapes on 2007 Spreadsheets
 

These are all issues I've experienced. Excel 2007 is slower than 2003,
particularly when dealing with shapes, charts, and extensive screen
refreshes. I haven't experienced problems, but others have reported issues
with printing of Excel 2007 charts and shapes (but I recall occasional
reports about other Excel versions too).

I don't really have any remedies.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______



"BillCPA" <Bill @ UAMS wrote in message
...
One other thing - if I print the worksheet, the arrowlines (shapes) do not
print in the correct position on the printed page, even tho they show up
in
the correct positions on the displayed worksheet. Excel 2003 printed
correctly.

--
Bill @ UAMS


"BillCPA" wrote:

Is there some problem with having shapes on spreadsheets in Excel 2007?

I have a bank reconciliation program that matches book entries with bank
deposits. Both book and bank data comes in electronically, and I use
macros
to match the entries. In many cases there are multiple book entries that
total to one bank deposit. The macro groups these multiple book entries,
draws a box (borders) around them, and then draws an arrowline (shape)
from
the boxed group to the corresponding bank deposit. There are anywhere
from
$200-300M dollars in deposits each month, so the spreadsheet is quite
large.
In Excel 2003 it could easily take an hour to run.

In Excel 2007 this same process takes anywhere from 10-12 hours to run.
It
appears to have something to do with the shapes, because if I go into in
the
spreadsheet after it has been created, and page scroll from/to a page
with a
lot of the arrowlines on it, you can literally count the rows on the
screen
as it refreshes. If I page scroll from/to a page with no shapes on it,
it is
fairly instant. Or if I look at a worksheet with no shapes on it, the
page
scroll is also regular speed.

My assumption is that as the macro is creating the shapes at the
appropriate
places, it is somehow slowing down the processing, but that is only an
assumption. But I have no other clues. I do have Screenupdating turned
off
during processing.

Any ideas?
--
Bill @ UAMS

Shapes on 2007 Spreadsheets
 

I have info here about speed
http://www.rondebruin.nl/shape.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"BillCPA" <Bill @ UAMS wrote in message ...
One other thing - if I print the worksheet, the arrowlines (shapes) do not
print in the correct position on the printed page, even tho they show up in
the correct positions on the displayed worksheet. Excel 2003 printed
correctly.

--
Bill @ UAMS


"BillCPA" wrote:

Is there some problem with having shapes on spreadsheets in Excel 2007?

I have a bank reconciliation program that matches book entries with bank
deposits. Both book and bank data comes in electronically, and I use macros
to match the entries. In many cases there are multiple book entries that
total to one bank deposit. The macro groups these multiple book entries,
draws a box (borders) around them, and then draws an arrowline (shape) from
the boxed group to the corresponding bank deposit. There are anywhere from
$200-300M dollars in deposits each month, so the spreadsheet is quite large.
In Excel 2003 it could easily take an hour to run.

In Excel 2007 this same process takes anywhere from 10-12 hours to run. It
appears to have something to do with the shapes, because if I go into in the
spreadsheet after it has been created, and page scroll from/to a page with a
lot of the arrowlines on it, you can literally count the rows on the screen
as it refreshes. If I page scroll from/to a page with no shapes on it, it is
fairly instant. Or if I look at a worksheet with no shapes on it, the page
scroll is also regular speed.

My assumption is that as the macro is creating the shapes at the appropriate
places, it is somehow slowing down the processing, but that is only an
assumption. But I have no other clues. I do have Screenupdating turned off
during processing.

Any ideas?
--
Bill @ UAMS

Shapes on 2007 Spreadsheets
 

And Microsoft wonders why people get so mad at them.

--
Bill @ UAMS


"Jon Peltier" wrote:

These are all issues I've experienced. Excel 2007 is slower than 2003,
particularly when dealing with shapes, charts, and extensive screen
refreshes. I haven't experienced problems, but others have reported issues
with printing of Excel 2007 charts and shapes (but I recall occasional
reports about other Excel versions too).

I don't really have any remedies.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______



"BillCPA" <Bill @ UAMS wrote in message
...
One other thing - if I print the worksheet, the arrowlines (shapes) do not
print in the correct position on the printed page, even tho they show up
in
the correct positions on the displayed worksheet. Excel 2003 printed
correctly.

--
Bill @ UAMS


"BillCPA" wrote:

Is there some problem with having shapes on spreadsheets in Excel 2007?

I have a bank reconciliation program that matches book entries with bank
deposits. Both book and bank data comes in electronically, and I use
macros
to match the entries. In many cases there are multiple book entries that
total to one bank deposit. The macro groups these multiple book entries,
draws a box (borders) around them, and then draws an arrowline (shape)
from
the boxed group to the corresponding bank deposit. There are anywhere
from
$200-300M dollars in deposits each month, so the spreadsheet is quite
large.
In Excel 2003 it could easily take an hour to run.

In Excel 2007 this same process takes anywhere from 10-12 hours to run.
It
appears to have something to do with the shapes, because if I go into in
the
spreadsheet after it has been created, and page scroll from/to a page
with a
lot of the arrowlines on it, you can literally count the rows on the
screen
as it refreshes. If I page scroll from/to a page with no shapes on it,
it is
fairly instant. Or if I look at a worksheet with no shapes on it, the
page
scroll is also regular speed.

My assumption is that as the macro is creating the shapes at the
appropriate
places, it is somehow slowing down the processing, but that is only an
assumption. But I have no other clues. I do have Screenupdating turned
off
during processing.

Any ideas?
--
Bill @ UAMS

Shapes on 2007 Spreadsheets
 

Thank you - I will see what that does for me.

--
Bill @ UAMS


"Ron de Bruin" wrote:

I have info here about speed
http://www.rondebruin.nl/shape.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"BillCPA" <Bill @ UAMS wrote in message ...
One other thing - if I print the worksheet, the arrowlines (shapes) do not
print in the correct position on the printed page, even tho they show up in
the correct positions on the displayed worksheet. Excel 2003 printed
correctly.

--
Bill @ UAMS


"BillCPA" wrote:

Is there some problem with having shapes on spreadsheets in Excel 2007?

I have a bank reconciliation program that matches book entries with bank
deposits. Both book and bank data comes in electronically, and I use macros
to match the entries. In many cases there are multiple book entries that
total to one bank deposit. The macro groups these multiple book entries,
draws a box (borders) around them, and then draws an arrowline (shape) from
the boxed group to the corresponding bank deposit. There are anywhere from
$200-300M dollars in deposits each month, so the spreadsheet is quite large.
In Excel 2003 it could easily take an hour to run.

In Excel 2007 this same process takes anywhere from 10-12 hours to run. It
appears to have something to do with the shapes, because if I go into in the
spreadsheet after it has been created, and page scroll from/to a page with a
lot of the arrowlines on it, you can literally count the rows on the screen
as it refreshes. If I page scroll from/to a page with no shapes on it, it is
fairly instant. Or if I look at a worksheet with no shapes on it, the page
scroll is also regular speed.

My assumption is that as the macro is creating the shapes at the appropriate
places, it is somehow slowing down the processing, but that is only an
assumption. But I have no other clues. I do have Screenupdating turned off
during processing.

Any ideas?
--
Bill @ UAMS