Forum Discussion
Getting Data from Multiple Web Pages -- Replicate changes made using Query Editor
"duplicate it from the menu (right click on the query) and use for another web page."
I cannot find any such option. I am using Excel 2016 on Office 365.
That's in Queries&Connections pane in Excel sheet or in Queries pane in Query editor
I already tried duplicating, but as I said earlier -->
"There is an option to duplicate the in the Query editor, when I used the same, and duplicated one sheet, and changed the Data source, to be able to apply the same changes to the data from the 2nd source, it pulled the raw data, and the changes which I applied to the first sheet, were not replicated to the 2nd sheet."If I understood you correctly you'd like to sync changes, i.e. if you changes something in Query1 it shall be reflected in Query2. If so the function is required which you'll be use in both queries. Duplication is just kind of copy/paste, duplicated query lives independently of the source.
Thanks, it finally worked. I had to get into Data - Queries & Connections - Select the specific Table - Edit - Advanced Editor and then change the Source.
However, with 30+ worksheets, the computer, started giving Out of Memory errors, had to upgrade Excel from 32 Bit to 64 Bit, now the Out of Memory errors are not coming, but the computer has become very slow.
I have 100 more sheets, to pull, wondering what to do, does not seem excel can support so many worksheets.Should I make multiple excel files, but then how do I combine all the data, as I am doing now, using Append.