Here's one of life's great mysteries (to me anyway). I'm a novice Excel user, but I'm trying to populate a workbook provided to me as part of a project. New Entries or modifications on the setup page are supposed to flow through other related pages in the worksheet but they don't. I enter new data, click update and nothing transfers. There are a number of us working the same project having the same problem.
Here's the kicker--my colleague, two desks over, has taken the workbook I sent him and successfully entered data which transferred so formulas, etc are obviously OK. Our Excel versions and IT setups are identical and Excel settings (macro security, etc) seem to be ok as well. We've gone through the process and he's not doing anything different from me.
To further baffle me--if he makes amendments and sends the file back to me, then I can make amendments as well!! But if I open the file from scratch, I'm back to square one.
I'm hesitant to forward the working file he's sent me to other colleagues as I still don't understand what's not working and would like to know I'm providing a good platform for the work.
Hi Johnny The Share workbook box wasn't ticked, but I believe this is a stand alone workbook (i.e. not linked--we're all making our own separate inputs). I've ticked the box now, but don't think it will have any effect on what anyone else is doing (and it hasn't made it work for me, either!!)