I currently have an excel workbook has two tabs -- A user entry/results tab and a calculation tab. The calculation tab plugs the entered information into a number of confidential formulas and spits a number back out on the results tab.

I'm trying to figure out a way I can share a version of the entry tab with our business users (thru intranet download or limited local Sharepoint) without giving them "access" to the confidential information in the rest of the process, so if that means breaking the first tab out into it's own workbook and "pinging" a second source (workbook?) or some other method with the information, then maybe a possibility. Having some sort of entry log would also be a plus. Just locking the workbook/tabs would not be good enough in this situation, as I'd like to avoid any sort of local download of the actual confidential info.

Unfortunately, I don't have many other options then to use Excel or maybe some other basic method, so I'm just trying to figure out potential options. I definitely understand this would not be an optimal way of doing this, just looking for ideas!

Summary: Create a "shared" form that runs inputs through confidential calculations and returns an answer to the user.