This is amazing, thanks for sharing ! Pro -tip: If you're using Mac - It will save as Complete Webpage - Open with Notes - Everything is pre-formatted and you can copy directly to new sheet :)
I've been using the 'change edit to preview' method for a long time and today suddenly it didn't work. Found your video after a quick search and this works seamlessly! You, Sir, are amazing! And you've earned a sub :) Keep it up!
Thanks for sharing! It worked like a charm. One note on your description, there it says htmlpreview instead of htmlview which had me scratching my head for a minute.
Does not work. Just takes me to a page that says, "Sorry, the file you have requested does not exist." It literally existed a moment ago when I was looking at it.
Note that if your excel file has multiple tabs, clicking on one will redirect you to that online site that doesn't allow editing. The solution is searching for and removing the "href={URL THAT THE SITE IS LOADING}" part. Note that you shouldn't actually break the buttons (the part) since they're also responsible for loading the respective tab contents
hi, i have done as you said and successfully copied 1 page from sheet. however, when i tried to do the same with the 2nd, 3rd, etc, the sheet reloaded and i couldn't copy it. how can i fix the prob? tks
When you are saving the doc, have it viewing on the sheet that you are trying to do. Then repeat the process. You have to save a file for each individual sheet you are trying to copy
Hey, I had the same problem. I'll repost my comment below: Note that if your excel file has multiple tabs, clicking on one will redirect you to that online site that doesn't allow editing. The solution is searching for and removing the "href={URL THAT THE SITE IS LOADING}" part. Note that you shouldn't actually break the buttons (the part) since they're also responsible for loading the respective tab contents
This is amazing, thanks for sharing ! Pro -tip: If you're using Mac - It will save as Complete Webpage - Open with Notes - Everything is pre-formatted and you can copy directly to new sheet :)
I've been using the 'change edit to preview' method for a long time and today suddenly it didn't work. Found your video after a quick search and this works seamlessly! You, Sir, are amazing! And you've earned a sub :) Keep it up!
Thanks so much big brother. You are really great boss. I watch 55+ video no one is working without your video. it helps so much. 😍😍😍
saviour thank you for the description too! made things super fast and concise! subbed!
Thanks for sharing! It worked like a charm. One note on your description, there it says htmlpreview instead of htmlview which had me scratching my head for a minute.
Just waht i was searching for. thanks a tone!!!!
can I use an import syntax (e.g. importrange, importdata, importhtml) to automate copy from the view only google sheet?
Thanks Max!
You got a subscriber!
Is it working now? I just checked and not working for me.
Does not work. Just takes me to a page that says, "Sorry, the file you have requested does not exist." It literally existed a moment ago when I was looking at it.
Brilliant! Thanks a million!!
saved me hours, works as shown thanks
It works perfectly
coollll, you are the besttt. love you bro!
Thanks man, saved my life :-) 14 Dec. 2024
I love you bhai❤
Thanks A TON
Thanks a lot man you are gr8❤
I did it. Thank you very much.
what if its has macro will it still work?
Thanks very much, worked perfectly
thanks buddy!
That works
You are the GOAT
Thank you so much!!!
Awesome great Job
i tried but it don't work if the link have many sheets
Thanks for sharing 😘
Awesome, is there any way to do the same in a restricted zohoo sheet?
it works. thanks
Thank you _>
mine i need to copy has special color filling
Thanks it worked
THANKKK YOUUUUUUUUUUU ❤🎉
Does not work for subsheets :(
Note that if your excel file has multiple tabs, clicking on one will redirect you to that online site that doesn't allow editing. The solution is searching for and removing the "href={URL THAT THE SITE IS LOADING}" part. Note that you shouldn't actually break the buttons (the part) since they're also responsible for loading the respective tab contents
@@thodorisevangelakos this is the way. But you have to delete ALL THE HREF or else the page still reloads. I tried and succeeded today
Thanks!
thank you so much love you bro
thanks bro
I don’t think it works for apple any suggestions
hi, i have done as you said and successfully copied 1 page from sheet. however, when i tried to do the same with the 2nd, 3rd, etc, the sheet reloaded and i couldn't copy it. how can i fix the prob? tks
When you are saving the doc, have it viewing on the sheet that you are trying to do. Then repeat the process. You have to save a file for each individual sheet you are trying to copy
@@moanasangeo2384 thanks for your suggestion. i have found a way to fix the problem. turning out wifi before selecting next page helped me fix it.
@@moanasangeo2384 It did not work even when I navigated to page 2 and saved it. Do you have any other method?
Please let me know if you found any work around
Hey, I had the same problem. I'll repost my comment below:
Note that if your excel file has multiple tabs, clicking on one will redirect you to that online site that doesn't allow editing. The solution is searching for and removing the "href={URL THAT THE SITE IS LOADING}" part. Note that you shouldn't actually break the buttons (the part) since they're also responsible for loading the respective tab contents
You...Thank you so much…
it not worked for me
thank you so much
Thanks
F for Mr Beast
This no copy formulas , only text !!!
god damm bro!!!! so fk good
Doesn't work!
its old
Don't think this works anymore.
but you cant download the formulas. btw thank you
Not working now
skill issue
does not work