Microsoft Query "Greater Than Or Equal To" Invoice Date Criteria Filter Not Updating

%3CLINGO-SUB%20id%3D%22lingo-sub-1362164%22%20slang%3D%22en-US%22%3EMicrosoft%20Query%20%22Greater%20Than%20Or%20Equal%20To%22%20Invoice%20Date%20Criteria%20Filter%20Not%20Updating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362164%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20this%20is%20my%20first%20post.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20creating%20a%20report%20using%20Microsoft%20Query%20through%20Microsoft%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20a%20cell%20reference%20as%20a%20parameter%20in%20the%20criteria%20filter%20in%20the%20query%20for%20the%20invoice%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20criteria%20filter%20is%20%26gt%3B%3D%5BParameter%201%5D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EParameter%201%20is%20cell%20referenced%20to%20a%20cell%20with%20the%20formula%20%3DText(Today()-7%2C%22YYYMMDD%22).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Invoice%20Date%20filter%20is%20supposed%20to%20be%20for%20the%20previous%207%20days%20of%20invoices.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Parameter%201%20filter%20works%20the%20first%20time%20I%20use%20it%2C%20however%2C%20it%20doesn't%20refresh%20when%20I%20change%20the%20formula%20to%20a%20different%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20%22Refresh%20automatically%20when%20cell%20value%20changes%22%20box%20checked%2C%20however%2C%20it%20does%20not%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20click%20%22Refresh%20All%22%2C%20I%20get%20an%20error%20message%20that%20says%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22A%20PivotTable%2C%20cube%20function%20or%20filter%20control%20using%20the%20connection%20'Query%20from%20SQL'%20didn't%20refresh.%20Continue%20to%20refresh%20all%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20is%20the%20data%20not%20refreshing%3F%20Is%20there%20something%20wrong%20with%20my%20filter%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1362164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

Hi everyone, this is my first post.

 

I'm creating a report using Microsoft Query through Microsoft Excel.

 

I'm trying to use a cell reference as a parameter in the criteria filter in the query for the invoice date.

 

The criteria filter is >=[Parameter 1].

 

Parameter 1 is cell referenced to a cell with the formula =Text(Today()-7,"YYYMMDD").

 

The Invoice Date filter is supposed to be for the previous 7 days of invoices.

 

The Parameter 1 filter works the first time I use it, however, it doesn't refresh when I change the formula to a different date.

 

I have the "Refresh automatically when cell value changes" box checked, however, it does not refresh.

 

When I click "Refresh All", I get an error message that says:

 

"A PivotTable, cube function or filter control using the connection 'Query from SQL' didn't refresh. Continue to refresh all?"

 

Why is the data not refreshing? Is there something wrong with my filter?

 

 

0 Replies