Excel 2003 / 2007 function

  • Thread starter Thread starter JaphyRider
  • Start date Start date
J

JaphyRider

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 >>
 
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)
 
Bob,
Thank you for the reply. The problem occurs whether macros enabled or
disabled.
--
J


Bob Phillips said:
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)
Click to expand...
 
Back
Top