Data Disappears+Comments Added to Cells

[vkossoski]

Hello all,

I am an excel newbie and this is probably a very rudimentary error nevertheless I really would appreciate some your expert assistance on this matter. Data disappears/comments are added when I attempt to filter columns and also when I use autofill to populate columns. I have attached some screenshots to help clarify the matter. Thank you in advance!

[nielsbosma]

The columns with the formulas aren't included in the filters.

The error makes sense. Look at the formula. A2 is empty and that isn't a valid input to the connector.

Dump need to add the comments to know what range it's maintaining.

/Niels