Using Excel formulas from Access table source (1 Viewer)

raziel3

Registered User.
Local time
Today, 05:51
Joined
Oct 5, 2017
Messages
273
Hello all, it is possible to use an excel formula to reference data from an access table. For example I have a cell on an excel spreadsheet where I enter a date and another cell with a Sumifs formula to get value based on the relevant criterias.

Yes I know I can create a query in Access and and link it to the excel spreadsheet but the reports that I need to reproduce requires queries with 3 or 4 subqueries and it's really a pain to have to design it when I can create it with a few Sumifs in excel.

Basically I want to store the records in access and do the calculations in excel without having to import the data.
 

GinaWhipp

AWF VIP
Local time
Today, 05:51
Joined
Jun 21, 2011
Messages
5,901
You cannot link a cell in Excel to a field in a Table in Access.
 

Users who are viewing this thread

Top Bottom