P
PeteJ
I have a multi-worksheet file in Excel 2007. One of the worksheets imports
data from a table on a web page using a web query. A second sheet picks off
certain data from the first sheet, so that I can see it organized in a way
that I want to see it.
Occassionally, after I refresh the data on the first sheet, a row on the
second sheet is gone. It appears to be the same row each time, row 28,
nothing remarkable about that row since all the rows have formulas that are
basically just grabbing data from the first sheet. I can tell by the formulas
in the row above and below that the row is just missing. Other than fixing
the row that gets deleted, I never edit this sheet, since it is just for
viewing.
There are no macros in the file, I can't figure out what's going on. Is it
possible that the import onto sheet 1 somehow affects sheet 2? Again, Sheet 1
is just a web query of text data from a table on a web page, no formulas or
macros.
Any ideas on how to find out what the cause is?
Thanks,
- Pete
data from a table on a web page using a web query. A second sheet picks off
certain data from the first sheet, so that I can see it organized in a way
that I want to see it.
Occassionally, after I refresh the data on the first sheet, a row on the
second sheet is gone. It appears to be the same row each time, row 28,
nothing remarkable about that row since all the rows have formulas that are
basically just grabbing data from the first sheet. I can tell by the formulas
in the row above and below that the row is just missing. Other than fixing
the row that gets deleted, I never edit this sheet, since it is just for
viewing.
There are no macros in the file, I can't figure out what's going on. Is it
possible that the import onto sheet 1 somehow affects sheet 2? Again, Sheet 1
is just a web query of text data from a table on a web page, no formulas or
macros.
Any ideas on how to find out what the cause is?
Thanks,
- Pete