Looking for some help/guidance on integrating Microsoft Excel with other business applications

%3CLINGO-SUB%20id%3D%22lingo-sub-1797151%22%20slang%3D%22en-US%22%3ELooking%20for%20some%20help%2Fguidance%20on%20integrating%20Microsoft%20Excel%20with%20other%20business%20applications%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1797151%22%20slang%3D%22en-US%22%3E%3CP%3ECurrently%20we%20are%20using%20Excel%20to%20model%20various%20business%20scenarios%20created%20and%20maintained%20by%20individual%20users%20with%20their%20own%20versions%20and%20copies%20of%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20is%20the%20best%20application%20in%20what%20its%20doing%2C%20with%20visible%20calculations%20etc.%20but%20each%26nbsp%3B%20copy%20is%20standalone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20am%20looking%20for%20is%20to%20integrate%20several%20copies%20of%20excel%20from%20various%20users%20and%20save%20the%20data%20in%20a%20backend%20database%20so%20that%20I%20could%20use%20these%20data%20further%20for%20next%20level%20of%20integration%20with%20other%20business%20applications.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20extending%20excel%20to%20a%20fully%20integrated%202-tier%20or%20n-tier%20application.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20if%20there%20is%20any%20product%20in%20Microsoft%20already%20that%20would%20address%20this%20requirement%20that%20we%20could%20use%20instead%20of%20re-inventing%20the%20wheel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20were%20thinking%20of%20developing%20a%20web%20based%20application%20to%20mimic%20a%20spreadsheet%20but%20I%20thought%20there%20might%20be%20a%20ready-made%20product%20in%20the%20market%20that%20we%20could%20make%20use%20of.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20here%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1797151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801552%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20some%20help%2Fguidance%20on%20integrating%20Microsoft%20Excel%20with%20other%20business%20applications%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F838340%22%20target%3D%22_blank%22%3E%40rthoppe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20Power%20Query%20could%20work%20for%20the%20collecting%20of%20information%2C%20very%20depends%20on%20data%20design.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Currently we are using Excel to model various business scenarios created and maintained by individual users with their own versions and copies of excel.

 

Excel is the best application in what its doing, with visible calculations etc. but each  copy is standalone.

 

What I am looking for is to integrate several copies of excel from various users and save the data in a backend database so that I could use these data further for next level of integration with other business applications.

 

Basically extending excel to a fully integrated 2-tier or n-tier application.

 

Wondering if there is any product in Microsoft already that would address this requirement that we could use instead of re-inventing the wheel.

 

We were thinking of developing a web based application to mimic a spreadsheet but I thought there might be a ready-made product in the market that we could make use of.

 

Any assistance here is appreciated.

1 Reply
Highlighted

@rthoppe 

Perhaps Power Query could work for the collecting of information, very depends on data design.