AnsweredAssumed Answered

Connecting a FMP solution to an Excel workbook

Question asked by dwirony on Jul 6, 2018
Latest reply on Jul 6, 2018 by beverly

My apologies if this question is too broad - I've been looking into how to have an Excel worksheet dynamically pull data from a FMP solution. For example, if I have a worksheet named "Sheet1" in my workbook with two columns, "Test Date" and "Test Number", I'd like it to contain all records from my FMP solution for those two fields - It is to my understanding that this should be possible, no? If so, how do I go about building this connection?

 

To elaborate, instead of manually running an export from FMP and pasting the exported data into Excel, I'd like to be able to refresh my workbook and have it pull in the new data automatically.

Outcomes