I am a newbie and need help. I used an ODBC driver to import data to Excel. I then added two columns to the left (Column A and B) of the data with formulas to calcuate age. Now I have a couple of problems. I think the problem is with the two columns that I added but not sure. I don't see anwhere here to include an attachment. Sorry -
1. When I click the filter button, the filter turns on for the exported data but not for the two columns I added. Is there a way I can click the filter button and it will turn on for all of the columns? I tried selecting the row and the filter button was grayed out. As a workaround, I highlighted cell A1 to turn on the filter for the two columns I created.
2. I cannot filter the entire spreadsheet. The first two columns filter but it does not match up with the filtered data from the external source
3. I created a formula that uses data from columns A and Columns F and V. I refresh my data and the formulas no longer work. I get "N/A"
1. When I click the filter button, the filter turns on for the exported data but not for the two columns I added. Is there a way I can click the filter button and it will turn on for all of the columns? I tried selecting the row and the filter button was grayed out. As a workaround, I highlighted cell A1 to turn on the filter for the two columns I created.
2. I cannot filter the entire spreadsheet. The first two columns filter but it does not match up with the filtered data from the external source
3. I created a formula that uses data from columns A and Columns F and V. I refresh my data and the formulas no longer work. I get "N/A"
