Excel 2003 / 2007 formulas

[J]

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

 

[Bob Buckland ?:-\)]

Hi J.,

You may want to use the link below to also post in the MS Office Excel discussion group. If you can provide a link to the problem
worksheet that may also help, as well as mention the version of Windows and any add-ins that may be loaded.

============
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 >>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com