This is my first post i hope i get a clear answer for my question.
I recenty have been working on KPI's drawn from Microsoft Excel documents that i created. However, as we know, external data sources in excel don't work with sharepoint. If that was possible it would have saved the company a lot of time and effort
My questions are:
Is there any way to have external data sources with some advanced modifications, or any other way that would simulate this process? (External data update)
Can i directly update my data by tampering the database where the excel file is saved?
I don't know if the files uploaded in sharepoint are stored in a database, so i want some validation around this. (Name of the database, path etc.)
Hope you can shed some light to my questions
Thanks in advance
View Complete Post