Input Data in Excel, Receive Results at same Form, the Calculation must be done in a separate Excel Workbook.

Question

Hello,

I have a very Big Excel File which has a lot of Formula.

at this File, I have some Input Cells and some Output Cells as Results.

Now I want to separate this Summary (Input, Output cells) from this Workbook, and create a new Workbook but still, have the Funktion.

The point is that the User has no Access to Databank (Big Excel File) can only Input the data an see the Results in Output Cells.

These Output Cells calculate the values with Formulas.

Could you please give me some Solution?

Summary :

Answer 1

Hi Hossein,

May I know if you have checked my last reply about link from one workbook to anohter in a SharePoint Online document library? Feel free to let us know if you have any further concerns.

Best Regards,

Nathan

Answer 2

Hello Nathan,

thanks for your answer, the problem is that I can not share the database excel File with User.

the User must have no access to the Database Excel File.

I think it is not possible only with Excel features, because it is not Dynamic change when I change the input from the Form.

I think I have to do it with programming, but I am not sure which program is suitable to this Issue.we want to use this Form online in SharePoint, which is connected to big Excel file.

I really appreciate if you have some solution.

Best Regards

Hossein

Answer 3

Hi Hossein,

Please check my reply in your latest thread. If you doesn't want to use a SharePoint list to replace your database workbook, I'd recommend voting for this thread in the Exel for the web forum in UserVoice: Links between spreadsheets in Excel Online, higher vote numbers may help to left the priority of this feature in the plan of the programming team.

Best Regards,

Nathan