 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Excel 2003 / 2007 function
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 >>  Signature-- 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? SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hello, > I have a spreadsheet that is shared on a server. It was created [quoted text clipped - 9 lines] > Any ideas! > TIA >> Bob, Thank you for the reply. The problem occurs whether macros enabled or disabled. SignatureJ > 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 [quoted text clipped - 14 lines] > > Any ideas! > > TIA >> 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 > Hello, > I have a spreadsheet that is shared on a server. It was created [quoted text clipped - 9 lines] > Any ideas! > TIA >> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.