"Get Data From Folder" populates column but needs "F2" in each cell for Vlookup to detect info.

[burnthills]

Hello all,

First, thank you all so much for helping me get this far:

I have one sheet that pulls the list of files in a folder and populates column A. It was working fine for a while but as I needed better functionality, the formulas got fairly complex and now something is different when I hit "Refresh All" to re-run the query:

The cells fill out and filter fine but now each cell, even if formatted as "General", needs me to hit F2 for VLOOKUP to actually match the data correctly.

My troubleshooting testing simple cell "=VLOOKUP(B23,WeekeBlue!A:A,1,FALSE)" returns #N/A now unless I hit F2 in every single of the thousands cells on the imported data to get formulas to be able to read it.

Anyone seen this before? Thanks in advance.

uploaded here:

Google Sheets - create and edit spreadsheets online, for free.

Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.

docs.google.com

 

[johnny51981]

Have you checked your Calculation Options to make sure it is set to Automatic? I've had times where it somehow finds its way to Manual.
Formulas Tab > Calculation Group > Calculation Options

 

[burnthills]

Everything is set to Automatic, thank you.