Hello,
I have a spreadsheet that is shared on a server. It was created
using Excel 2003. It has some formulas that calculate price for a product.
The 2003 user puts an 'x' in certain cells to selection size, color,
etc. For 2003 the price is automatically calculated from the combination
of check marked cells.
For the 2007 user, it doesn't do the calculation 'all the time'. I
haven't really figured out a pattern, but sometimes the user will add
an 'x' to a cell that should trigger a price change, then 'enter' or
'tab', but it doesn't always work.
Any ideas!
TIA >>
--

--
J

In Excel 2007, it has a discerning habit of opening spreadsheets that have
macros and not asking if you want them enabled, but puts a button on or
about the formula bar that allows you enable macros. Could this be happening
at times?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JaphyRider" <JaphyRider@discussions.microsoft.com> wrote in message
news:665DB1B0-A44B-45D5-AA2F-ED92061EEC66@microsoft.com...
> Hello,
> I have a spreadsheet that is shared on a server. It was created
> using Excel 2003. It has some formulas that calculate price for a
> product.
> The 2003 user puts an 'x' in certain cells to selection size, color,
> etc. For 2003 the price is automatically calculated from the combination
> of check marked cells.
> For the 2007 user, it doesn't do the calculation 'all the time'. I
> haven't really figured out a pattern, but sometimes the user will add
> an 'x' to a cell that should trigger a price change, then 'enter' or
> 'tab', but it doesn't always work.
> Any ideas!
> TIA >>
> --
>
> --
> J

Bob,
Thank you for the reply. The problem occurs whether macros enabled or
disabled.
--
J


"Bob Phillips" wrote:

> In Excel 2007, it has a discerning habit of opening spreadsheets that have
> macros and not asking if you want them enabled, but puts a button on or
> about the formula bar that allows you enable macros. Could this be happening
> at times?
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "JaphyRider" <JaphyRider@discussions.microsoft.com> wrote in message
> news:665DB1B0-A44B-45D5-AA2F-ED92061EEC66@microsoft.com...
> > Hello,
> > I have a spreadsheet that is shared on a server. It was created
> > using Excel 2003. It has some formulas that calculate price for a
> > product.
> > The 2003 user puts an 'x' in certain cells to selection size, color,
> > etc. For 2003 the price is automatically calculated from the combination
> > of check marked cells.
> > For the 2007 user, it doesn't do the calculation 'all the time'. I
> > haven't really figured out a pattern, but sometimes the user will add
> > an 'x' to a cell that should trigger a price change, then 'enter' or
> > 'tab', but it doesn't always work.
> > Any ideas!
> > TIA >>
> > --
> >
> > --
> > J
>
>
>

Have you tried putting "Application.Volatile" as the first line in the
function? This forces the function to recalculate when any cell in the
worksheet is changed.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"JaphyRider" <JaphyRider@discussions.microsoft.com> wrote in message
news:665DB1B0-A44B-45D5-AA2F-ED92061EEC66@microsoft.com...
> Hello,
> I have a spreadsheet that is shared on a server. It was created
> using Excel 2003. It has some formulas that calculate price for a
> product.
> The 2003 user puts an 'x' in certain cells to selection size, color,
> etc. For 2003 the price is automatically calculated from the combination
> of check marked cells.
> For the 2007 user, it doesn't do the calculation 'all the time'. I
> haven't really figured out a pattern, but sometimes the user will add
> an 'x' to a cell that should trigger a price change, then 'enter' or
> 'tab', but it doesn't always work.
> Any ideas!
> TIA >>
> --
>
> --
> J