Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Some background... I wrote a python program that queries a database, exports the data into an xlsx spreadsheet and then adds that data into a template with existing formulas.
The issue I'm having is after the data is added to the template and the file saved; when I access the template most of the formulas are now array formulas but they aren't meant to be. Example below
If I highlight the cell with the formula, click the formula bar, and hit enter, the brackets remove, and the formula works again. Otherwise, it's only pulling a single line of data. I don't really want to select 10 cells after the template is saved and do this process, I'd rather have it automatically do it when the workbook is opened using VBA but I'm not sure where to begin?
The issue I'm having is after the data is added to the template and the file saved; when I access the template most of the formulas are now array formulas but they aren't meant to be. Example below
Excel Formula:
{=IF($D$1="","",FILTER(Sheet1!I3:I400000,(Sheet1!E3:E400000=$D$1)*(Sheet1!F3:F400000=1)))}
If I highlight the cell with the formula, click the formula bar, and hit enter, the brackets remove, and the formula works again. Otherwise, it's only pulling a single line of data. I don't really want to select 10 cells after the template is saved and do this process, I'd rather have it automatically do it when the workbook is opened using VBA but I'm not sure where to begin?
Last edited: