Hi all,
This is my first post - sorry if this has been answered before (I'm guessing it has).
I have an excel workbook with multiple sheets. "Sheet A" pulls data from an MLB website via web query. This updates daily and I have no issues with the data being imported. On "Sheet B", I pull information from "Sheet A" - specifically, "Sheet A" C15 - C40. For example, on "Sheet B" in cell A1, I have "='Sheet A'!C15" and it pulls the information correctly. However, overnight, it seems that the web query goes "blank" or stops importing, and my formula is automatically changed to "='Sheet A'!#REF!" and it will not pull information from "Sheet A" even when the web query on "Sheet A" updates. Can someone help with this? Thank you very much in advance!
-Barrett
This is my first post - sorry if this has been answered before (I'm guessing it has).
I have an excel workbook with multiple sheets. "Sheet A" pulls data from an MLB website via web query. This updates daily and I have no issues with the data being imported. On "Sheet B", I pull information from "Sheet A" - specifically, "Sheet A" C15 - C40. For example, on "Sheet B" in cell A1, I have "='Sheet A'!C15" and it pulls the information correctly. However, overnight, it seems that the web query goes "blank" or stops importing, and my formula is automatically changed to "='Sheet A'!#REF!" and it will not pull information from "Sheet A" even when the web query on "Sheet A" updates. Can someone help with this? Thank you very much in advance!
-Barrett
