Get data from an excel file in onedrive with power query
I used to download data from my excel files that are in one drive using the file URL and modifying the embed to download. https://onedrive.live.com/redir.aspx?cid=31XXX007X973ee6b&resid=3XXXXXC973EE6B!49999&parId=3XXXXXC973EE6B!46489&authkey=!ANrZXXXSdDCDJ0 Now the URL has changed to: https://1drv.ms/t/c/3XXXXXC973ee6b/EWvuc8kHcMcggDE6wwXXXXXBSTsVubH5dQtJKs7ZY8tlZg?e=PdwXXk and is useless to get data from web... I need help for a work around. thanks
Unable to open an excel sheet in my browser due to unsupported features
Hi All, This pop up has been appearing recently on my Excel Sheets which is an issue because I collaborate with people who do not have access to the desktop app: I've checked the What-If Analysis section and found these scenarios automatically created by "Village Software" who I've never heard of :( Removing them does nothing as it re-adds itself.
网赌被黑无法提现该怎么办？
（wx:zdq1136）（QQ：3321499968）（飞机@zdq1136）先出款，后收费! I have a macro that I've written to "reformat" some data in Excel (not font types and colors and such, but how the data is laid out in the spreadsheet). I found a macro that records how long it takes a macro to run, and that macro consistently runs for about 30 seconds. The problem is that the reason I'm reformatting the data is to import into Access, and I don't want my users to have to have intimate knowledge of Access or Excel to reformat the data and import it into the Access database. Thus, I've created a form with a button that allows the user to select a file from a dialog box, and then the macro runs on that file. Ad for some reason, when done this way, the macro takes upwards of 6 minutes. I don't know if it would be helpful to post the code of the macro here, or if there's some generic advice that will help. I just can't imagine why this increase in run-time is happening.
Stop Microsoft's nagware pop ups
Once more, I'm on a new computer which has reset all of Microsoft's nagware pop ups that remind me how to use a product I've used for literal decades. "Did you know you can click here and do this". "I see you went to a new menu, did you know you could see ____ in this menu but you can't actually see it because this intrusive pop up is blocking it?" "Here is another pop up that deselected the cell you were currently typing in and you didn't notice is for 5 minutes so you have to redo everything you just worked on. Sucks to be you." How the hell do I get this nagware garbage to go away forever and never, ever, ever, ever, ever, ever come back?!
