You can incorporate data on a spreadsheet with data in Sage 100 to create a report.  We show you how to do that in the Sage University Advanced Sage Intelligence Reporting course.  We are offering an Intermediate course on October 7 which is the recommended prior to the Advanced course.  You can learn more about all of the courses and see when the are offered by clicking here and looking under the topic Sage Intelligence Reporting

Question:

Is it possible to link Excel Sheet into SAGE 100 specific table and update their data in real-time? For example, I want to update specific column from my Excel (Aged Receivables) and once saved, the counterpart SAGE100 should also be updated and (vice-versa). Thank you in advance.

Read from Sage 100: yes.

Push data from the spreadsheet into Sage 100: no.

Thanks for the info Kevin, but is there any other work around that we can update data using either of the two since excel is capable to connect to SAGE100 using ODBC adapter and able to see tables of SAGE? Anyone who already tried and experience it? I'm still trying to find a solution for that. Thank you.

The Sage 100 ODBC driver is read-only.  You absolutely cannot push data from Excel into Sage 100.  The whole idea of a system like Sage 100 is to maintain an audit trail of all transactions, and casually editing raw data directly is blocked purposefully.

You can import data from a spreadsheet using the Visual Integrator module, using the Sage business objects, maintaining data integrity.

Thanks for the information Kevin.