Is it possible to exclude cells with formulas and no data from showing in
another Excel file that is linked?

The formulas only put data in the cell if other conditions are met, so if
those conditions are not met and the cells do not display data, they
shouldn't be seen in the Excel file that is linked to it.

Hopefully thad made sense.