I have a spreadsheet into which I pull data from a web page-based table that gets updated every day with a refresh command.
I actually have two tabs for this purpose: one tab reflects "all players", and the other reflects "active roster" players only. These are two different subsets of total players. The difference in the formula between the two tabs is, the field ros=0 applies to all players, and the field ros=1 applies only to active roster players.
When I built the table with the original two formulas, the two tabs showed separate results, as intended. BUT: whenever I try to change any other field on either of them, it changes the entire formula on the other tab to match exactly, instead of maintaining it as a distinct different formula.
IOW, now the two tables show identical results, because they are drawing from the exact same formula, and that's not supposed to happen. One table is supposed to reflect ros=1 and the other ros=0, but whenever I try to fix one, it automatically changes the other along with it. See what I mean?
I assume this is because the two tabs are in the same workbook, and there's some default setting that makes this happen. Is there a way I can fix some setting so I can maintain two discrete tabs of web-based data, without splitting them off into separate workbooks?
I actually have two tabs for this purpose: one tab reflects "all players", and the other reflects "active roster" players only. These are two different subsets of total players. The difference in the formula between the two tabs is, the field ros=0 applies to all players, and the field ros=1 applies only to active roster players.
When I built the table with the original two formulas, the two tabs showed separate results, as intended. BUT: whenever I try to change any other field on either of them, it changes the entire formula on the other tab to match exactly, instead of maintaining it as a distinct different formula.
IOW, now the two tables show identical results, because they are drawing from the exact same formula, and that's not supposed to happen. One table is supposed to reflect ros=1 and the other ros=0, but whenever I try to fix one, it automatically changes the other along with it. See what I mean?
I assume this is because the two tabs are in the same workbook, and there's some default setting that makes this happen. Is there a way I can fix some setting so I can maintain two discrete tabs of web-based data, without splitting them off into separate workbooks?
Last edited:
