19:50:16 From ILGAR ZARBALIYEV to Everyone : My special hello to Alan Murray:) 19:50:31 From Alan Murray to Everyone : Thank you, Ilgar 19:51:08 From Alan Murray to Everyone : Hello everyone 19:51:14 From Tea Kuseva to Everyone : Welcome everyone 19:54:06 From Guy Hunkin to Everyone : Hello everyone! 19:55:32 From Itai Goldstein [Microsoft] to Everyone : Hey everyone! 19:55:46 From Gudlaug Erna Karlsdottir to Everyone : Hi :) 19:56:30 From Alan Murray to Everyone : Hey Gudlaug 19:58:38 From Guy Hunkin to Everyone : Good to see you all :-) Long time... 20:01:57 From Alan Murray to Everyone : Hi everyone 20:02:59 From Patrick O'Beirne to Everyone : All the biggies are here! 20:03:11 From Claire Squibb to Everyone : Honoured to be in such exalted company! 20:03:19 From Angela Collins to Everyone : Why isn't Oz wearing a hat? 20:03:25 From Tea Kuseva to Everyone : Welcome everyone! 20:03:53 From Angela Collins to Everyone : I didn't believe that Oz had any hair - he is always wearing a hat! 20:04:25 From Eric Lane to Everyone : Oz shouldn't your hair be Excel Green? 20:04:53 From Oz to Everyone : Excel Green? That's for leprechauns. 😲 20:05:01 From Guy Hunkin to Everyone : So many great people here! It's an honor! 20:07:08 From Patrick O'Beirne to Everyone : Did you say FREE? 20:07:24 From Oz to Everyone : Angela LOL! 20:07:26 From Tea Kuseva to Everyone : The Expo Show Is FREE to attend. 20:11:05 From Faraz Shaikh to Everyone : We ❤️ Excel 20:15:20 From Alan Weaver to Everyone : Will Excel on the web include VBA? 20:16:10 From Mechelle Norton to Everyone : I find that I have to "open in desktop" often to get the functionality I need. Especially when concerned with Pivot Tables. 20:17:15 From Patrick O'Beirne to Everyone : We'll be waiting Alan. Saw a post today of a complaint having to move tons of VBA code to Python cos VBA not updated. 20:17:53 From Hiran De Silva to Everyone : Alan Weaver - No VBA. OfficeScripts which is a version of JavaScript. If you know JavaScipt you're good to go. 20:18:14 From Mechelle Norton to Everyone : macros are not supported on web version, are they? 20:18:22 From Faraz Shaikh to Everyone : I will love to see Power Query working WEB 20:18:31 From Erin Forestner to Everyone : yes can see 20:18:48 From Alan Murray to Everyone : Yes, Mechelle. Features such charts, CF and PT's are lacking. The formulas and collaboration are top though. 20:18:50 From Faraz Shaikh to Everyone : macros not supported on the web 20:18:53 From Mechelle Norton to Everyone : What @faraz Said! 20:18:58 From Patrick O'Beirne to Everyone : Not that good Oz. JS very limited access to Excel OM. But it is improving I'm told 20:19:01 From Guy Hunkin to Everyone : >> Will Excel on the web include VBA?Excel for the Web offers the next generation scripting language called Office JavaScript APIs. It runs cross platform, it's a modern programming language and you can use modern developer tools for coding and debugging. I am not aware of any plans to bring VBA tyo Excel for the Web. I suggest that you use Office JavaScript APIs instead. 20:21:55 From Claire Squibb to Everyone : I lost my Internet connection 20 minutes before starting to deliver an online course yesterday... Fortunately it came back 15 minutes later, but it was a sweaty start! 20:23:32 From Hiran De Silva to Everyone : To add to Guy, VBA won't port to 'Excel on the web'. It is based on COM, and based on VB6 (discontinued 20 years ago). Excel on the web works in the web browser, an entirely different architecture, which JavaScript is for. 20:23:38 From Gary Murray to Everyone : Thanks Raj 20:24:37 From Andreas Thehos to Everyone : Sorry for the pie Charts instead of bar Charts? 😂 20:24:47 From Faraz Shaikh to Everyone : 😂 20:25:01 From Guy Hunkin to Everyone : >> macros are not supported on web version, are they?There is an Action Recorder available in Excel for the Web. And you can create Office JavaScript scripts, save them and then run them again. Exactly like macros. 20:25:37 From Faraz Shaikh to Everyone : Thinking 🤔 is there a way to convert your VBA codes to Scripts ? 20:25:57 From Mechelle Norton to Everyone : @guy can you give a link for the Office JavaScript tutorial? 20:29:33 From Guy Hunkin to Everyone : >> I find that I have to "open in desktop" often to get the functionality I need. Especially when concerned with Pivot Tables.I'll be glad to hear more about the exact functionality that you miss in Excel for the Web. We are constantly improving the product and I'll be glad to learn more about what makes you switch to Desktop. This helps us to prioritize. 20:31:25 From Jess to Everyone : Functionality I miss on the web: Power query, doing most things with pivot tables, custom formats 20:31:58 From Tanja Kuhn to Everyone : Is this features only in the online version? 20:32:26 From Andreas Thehos to Everyone : Also availible in Excel 365 when working with online files. 20:32:40 From Faraz Shaikh to Everyone : Power Query for Excel for Web.. that will be lovely 20:32:51 From Alan Weaver to Everyone : I drive pivot tables with VBA (error checks, data extracts etc) so looks like Excel on the web won't handle either of these 20:32:54 From Guy Hunkin to Everyone : >> Is this features only in the online version?These features are available in Excel Desktop, as well. 20:33:09 From tempjk to Everyone : is this meeting just for web excel? 20:33:11 From Guy Hunkin to Everyone : >> Power Query for Excel for Web.. that will be lovelyThe work is in progress :-) 20:33:19 From Patrick O'Beirne to Everyone : Guy, I'll email my wish list ;). Just everything I currently get in an app with 30,000 LOC VBA 20:33:22 From Mechelle Norton to Everyone : @guy We collaborate through Teams. The first problem is that Teams only allowed me to download the Excel file or open in browser, but not in desktop. So I open in browser and then from there to desktop. Now I have 3 copies of this file "open" and I run out of memory on a 12Gb RAM machine. This also confuses SharePoint with the syncing. 20:33:36 From Faraz Shaikh to Everyone : Is there way to export version history into Excel 😃 20:33:46 From Hiran De Silva to Everyone : Guy, I think a lot of people think of Excel for the web as a 'replacement' for the desktop version. So their expectations are unrealistic (eg. expecting VBA to work in it). Please confirm is this the correct view? 20:34:34 From Patrick O'Beirne to Everyone : EFW seems to be for data consumers, not developers. 20:34:45 From Faraz Shaikh to Everyone : Excel for Web => Slicers 20:35:33 From Naresh Parmar to Everyone : Excel for web - need facility to resize Table. 20:35:40 From Faraz Shaikh to Everyone : Great this about sheet view you can make your own customize sheet view 20:35:56 From Faraz Shaikh to Everyone : And you switch to your view when you like it 20:36:17 From Oakley Turvey to Everyone : Also now on the VIEW Ribbon on desktop version 20:36:35 From Faraz Shaikh to Everyone : This handy when you we are collaborating 20:37:09 From Alan Weaver to Everyone : Good point from Patrick... we need tools to develop customised Excel products 20:37:34 From Alan Murray to Everyone : Question from Celia on YT - what happens to the sheet view when the workbook is closed? 20:37:43 From Faraz Shaikh to Everyone : OneDrive is great 20:38:08 From Raj Rawat to Everyone : My questions - 20:38:49 From Raj Rawat to Everyone : when you have lots of @ mentions in Excel workbook is there a way when you open that file can we see a list of all the cels where I am @ mentioned? 20:38:55 From Andreas Thehos to Everyone : Celia, you can store your view for personal use. 20:39:36 From Faraz Shaikh to Everyone : @Itai - Is there way to export version history into Excel 😃 and the comments ? 20:39:57 From Patrick O'Beirne to Everyone : For those of us on portable devices can you zoom up a bit more please? 20:40:17 From Raj Rawat to Everyone : next question - When you are sharing the workbook does the other person have to have Microsoft account ? 20:40:39 From Erin Forestner to Everyone : why can 20:40:40 From Mechelle Norton to Everyone : @raj yes 20:41:07 From Erin Forestner to Everyone : why can't we close data types so it doesn't shift the other ribbon items to the right? 20:41:18 From Claire Squibb to Everyone : Following up Raj, can they use a free account? 20:41:19 From Raj Rawat to Everyone : Thank you @ Mechelle :) 20:42:07 From Artur to Everyone : For Excel for the web will there be access to odbc data sources from the local computer? 20:43:44 From Itai Goldstein [Microsoft] to Everyone : >> Excel for Web => SlicersComing soon :) 20:43:55 From Faraz Shaikh to Everyone : Wow 🤩 20:44:02 From Itai Goldstein [Microsoft] to Everyone : >>Excel for web - need facility to resize Table.Coming soon :) 20:44:10 From Alan Murray to Everyone : Yay! 20:44:50 From Faraz Shaikh to Everyone : Can we see timeline or expected date for these new features showing up.. 20:45:05 From Alan Murray to Everyone : I think you can get Slicers for PT's on the web now. I think. But not for Tables. 20:45:12 From Itai Goldstein [Microsoft] to Everyone : >> Question from Celia on YT - what happens to the sheet view when the workbook is closed?It is saved, so you can come back to the file later and use the sheet view again. 20:45:43 From Alan Murray to Everyone : Thanks Itai 20:45:54 From Faraz Shaikh to Everyone : We need to add more information data type > such as airport, seaports, distance between the ports 20:45:57 From Patrick O'Beirne to Everyone : Now convert those dollars to stg by the exchange rate using the currency type :) 20:46:24 From John to Everyone : In my Data Types I only have 2 types: Stocks and Geography. Why is that? I have Office 365 20:46:47 From Alan Murray to Everyone : Question from Nabil on YT - Can we insert the pictures into the worksheet? 20:47:34 From Imtiaz Ali to Everyone : Are the values dynamic/static - if dynamic, how often are they refreshed? 20:47:43 From Itai Goldstein [Microsoft] to Everyone : >> when you have lots of @ mentions in Excel workbook is there a way when you open that file can we see a list of all the cels where I am @ mentioned?Currently no, but it's a good idea. Thanks. 20:48:44 From Raj Rawat to Everyone : question for Alan - Is it possible to share the chat history of this zoom meeting along with the answers? 20:48:52 From Itai Goldstein [Microsoft] to Everyone : >> @Itai - Is there way to export version history into Excel 😃 and the comments ?Sorry, what do you mean by export version history? 20:49:02 From Faraz Shaikh to Everyone : Some user data type don’t show up even they are on o365 subscription and latest version.. is the user missing something 20:49:17 From Hiran De Silva to Everyone : Artur: No access to local data (or external data) via ODBC. Data connectivity via a web API yes. Very nice too. 20:49:32 From Alan Murray to Everyone : @Raj - Yes 20:49:38 From Faraz Shaikh to Everyone : Can we list all the comments into Excel as list 20:49:54 From Patrick O'Beirne to Everyone : Oz, REST web API with oAuth? 20:50:01 From Federação Portuguesa de Aikido (FPA) PT 502477350 to Everyone : Great question @Faraz! I only have Stocks and Geography 20:50:10 From Patrick O'Beirne to Everyone : Sorry Hiran I meant 20:50:29 From Adrian Mundy to Everyone : Office version, does not keep up with Web version. Found this from earlier option like LET 20:51:07 From Itai Goldstein [Microsoft] to Everyone : >>Following up Raj, can they use a free account?Yes, Excel for the Web is free for consumer free account. 20:51:43 From Raj Rawat to Everyone : thank you @ Alan :) 20:51:47 From Itai Goldstein [Microsoft] to Everyone : (without the advantages of commercial business account) 20:51:56 From Mechelle Norton to Everyone : Data Types were introduced at Ignite: 20:52:27 From Lenovo to Everyone : can I share data types that I create - and have them be updated for others users when I update them? 20:53:32 From Andreas Thehos to Everyone : @Lenovo - upload them to Power BI. Your organization can use them when they have the righte licence model. 20:53:52 From Lenovo to Everyone : OK, thank you 20:54:59 From Mechelle Norton to Everyone : Quick Tutorial From Ignite on Data Types: https://youtu.be/S6aLbvlAw7Y 20:55:26 From Hiran De Silva to Everyone : @Patrick, I haven't used oAuth with OfficeScripts. But REST API, yes. Catch me later for a live demo. 20:55:47 From Jess to Everyone : A bit off topic but can someone direct me to a good tutorial for getting power BI set up organisationally? I have played with the desktop version but have struggled to get this set up for the organisation (I am an admin on our 365 account, we're a small org so I also have to cover IT...) 20:56:49 From Tea Kuseva to Everyone : We can share the chat log, no problem, Raj! 20:57:07 From Raj Rawat to Everyone : thank you Tia :) 20:57:10 From Patrick O'Beirne to Everyone : Jess don't you love it when you want to do something in Windows and it says "contact your network administrator" ! 20:57:31 From Jess to Everyone : @patrick story of my life right now 20:57:37 From Hiran De Silva to Everyone : @Patrick, so Excel on desktop, and Google Sheets, and Excel on the web can Get and Put to the same data. 20:59:10 From Mechelle Norton to Everyone : Are Data Types like structures? Can they be used as such programmatically? 20:59:52 From Raj Rawat to Everyone : PowerBi and PowerPivot bit too tech for me as I haven't used them at all :( 20:59:57 From Chris Stevens to Everyone : Pivot field showed Count rather than Sum? 21:00:40 From Faraz Shaikh to Everyone : Yeah !!! 21:00:45 From Mechelle Norton to Everyone : I LOVE PowerQuery! 21:00:45 From Alan Murray to Everyone : Non numeric @Chris 21:01:01 From Faraz Shaikh to Everyone : I ❤️ Power Query 21:01:04 From Patrick O'Beirne to Everyone : Ooooh Guy can we have a PQ .ExpandAllcolumns? 21:01:05 From Andreas Thehos to Everyone : Chris, if there is a text between your numbers or some empty cells 21:01:34 From Enrico de Crescenzo to Everyone : Wait a second, @Guy did you just say your PQ's father? You're the man!!!!! 21:01:48 From Patrick O'Beirne to Everyone : … recursively ? 21:02:03 From Andreas Thehos to Everyone : It's his Baby, Enrico 21:02:09 From Faraz Shaikh to Everyone : Yes that’s his baby @enrico 21:02:30 From Andreas Thehos to Everyone : 😂🤣 21:02:45 From Alan Murray to Everyone : Good to see you @Enrico 21:03:13 From Enrico de Crescenzo to Everyone : Ciao @Alan, I'll just stare at Guy in silent awe after the latest revelations :O 21:03:27 From Alan Murray to Everyone : ha ha 21:03:41 From Patrick O'Beirne to Everyone : V V nice link from PQ fields to custom datatype 21:05:26 From Mechelle Norton to Everyone : Is the data type part of a model? 21:05:56 From Andreas Thehos to Everyone : When can we use Connections as a data source for normal functions like FILTER, XLOOKUP ? Could it be possible? 21:06:26 From Faraz Shaikh to Everyone : Power Query for MAC 21:06:49 From Faraz Shaikh to Everyone : Power Query Editor for Mac. 21:07:52 From Guy Hunkin to Everyone : https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5?ui=en-US&rs=en-US&ad=US 21:09:10 From Alan Murray to Everyone : There was a question Guy for inserting the pictures from data types such as Geography to the grid 21:09:50 From Faraz Shaikh to Everyone : @guy - will we see Power Query for web 21:10:07 From Alan Murray to Everyone : Will LAMBDA functions be available beyond the workbook? 21:10:29 From Faraz Shaikh to Everyone : Power Query - Excel for Web 21:11:16 From Guy Hunkin to Everyone : >> @guy - will we see Power Query for webThe work is in progress however I don't have any specific timeline yet. 21:11:41 From Mourad to Everyone : dynamic array function in data Validation and Conditional Formating? 21:11:42 From Faraz Shaikh to Everyone : woow 21:12:08 From Mourad to Everyone : Dynamic array with Excel Table 21:13:09 From Faraz Shaikh to Everyone : Some user face difficulties to see the data type even through they are O365 Subscription and having the latest excel version. Is the user missing something to activate them ? 21:13:13 From Guy Hunkin to Everyone : >> Will LAMBDA functions be available beyond the workbook?We hear this a lot. Thank you for your interest! I encourage you to vote for this idea in Excel User Voice (https://excel.uservoice.com/) 21:13:28 From Mourad to Everyone : when do you make intellisense in Data Validation and Conditional Formating? 21:13:28 From Oakley Turvey to Everyone : Are we going to get the code prompt with LAMBDA? 21:13:35 From Alan Murray to Everyone : ok mate 21:13:42 From Mechelle Norton to Everyone : When to use Lambda vs Formual? 21:13:44 From Claire Squibb to Everyone : Is there any plan to have a tooltip for LAMBDA functions showing the arguments? 21:13:50 From Mechelle Norton to Everyone : *formulas 21:14:18 From Guy Hunkin to Everyone : >> Some user face difficulties to see the data type even through they are O365 Subscription and having the latest excel version. Is the user missing something to activate them ?It's probably an issue of the customer being on the Semi-Annual update channel. Try switching to the latest version on the Current Update Channel. 21:15:18 From Faraz Shaikh to Everyone : Thank You 😃 21:15:32 From Mourad to Everyone : FILTER Function, many thanks to #Excel team I have some suggestions to improve Filter function it will be better if you add the option to: I as 1) Extract many columns non-adjacents without using CHOOSE function 2) Extract Top or bottom n items without using LARGE or SMALL Functions 3) Using wildcards without using SEARCH or FIND Functions 21:15:43 From Guy Hunkin to Everyone : >> when do you make intellisense in Data Validation and Conditional Formating?Great suggestion! I suggest you vote for this idea on Excel User Voice (https://excel.uservoice.com/). It helps us to prioritize our work. 21:16:37 From Guy Hunkin to Everyone : >> Is there any plan to have a tooltip for LAMBDA functions showing the arguments?I took the note. Thanks for the feedback! 21:17:01 From Mourad to Everyone : I have some suggestions to improve Xlookup : 1) Add the option to search by range and by column position like Index Function, to be able to extract many columns even if they are Non-adjacents 2) Add the option to extract n item from Top or from the bottom, not just the first For Example I can fill all rows and all columns of this table from Ventes table by using Index/XMatch in one cell. But by Xlookup I can only fill all rows or all columns but all in the same time in same formula, and I can't return from columns that not adjacent. 21:18:00 From Patrick O'Beirne to Everyone : Limit 511 recursion limit 21:18:49 From Faraz Shaikh to Everyone : https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/42487501-power-query-number-filter-option-to-have-maximum-o 21:18:52 From Guy Hunkin to Everyone : >> When to use Lambda vs Formual?LAMBDA is for creating your own custom functions like Dror is showing. Think of it as a way to extend the existing formula language. If you need a custom logic for your solution - LAMBDA is the way to go! 21:19:45 From Markus Schlafmann to Everyone : the Lamda-function has to stay in the workbook?or is there a way to but it "in an AddIn"? 21:19:51 From Faraz Shaikh to Everyone : Are we going to see refine editor for lamda 21:19:56 From Andreas Thehos to Everyone : I Need optional Arguments in LAMBDA if the second Argument ist empty I Need to write =NameOFLAMBDAFunction(111,) 21:20:08 From Mourad to Everyone : when do you will add Wildcards or Regex in Power Query? 21:20:09 From Mechelle Norton to Everyone : Can you give a link to a Lambda tutorial? 21:20:34 From Roger Govier to Everyone : Sorry everyone, I have to leave now. Very many thanks to Itai, Guy and Dror for excellent presentations. 21:21:10 From Faraz Shaikh to Everyone : CTRL + M (shortcut key open power query editor) 21:21:11 From Mechelle Norton to Everyone : Did you say Lambdas are in Name Manager? Or was that the data cells you defined? 21:21:23 From Roger Govier to Everyone : I have been lloking forward to Lambdas for some while, and I am having a lot of fun playing with them. Bye everyone and thanks again 21:21:44 From Mourad to Everyone : any improvement to Pivot Table in the future? 21:22:36 From Alan Murray to Everyone : Thanks Roger 21:23:25 From Patrick O'Beirne to Everyone : Is there a notification service when something is posted in Excel/Whatsnew ? 21:23:28 From Guy Hunkin to Everyone : >> Can you give a link to a Lambda tutorial?Please start with this blog post:https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546And this is a good article, too:https://techcommunity.microsoft.com/t5/excel/lambda-examples-count-words-in-a-text-string/m-p/2061855#M85908 21:23:36 From Artur to Everyone : I don't see Power query Data types in my Excel app but I'm not on insider plan 21:23:46 From Michael to Everyone : Could all the links be sent in a follow up email? 21:24:00 From Tea Kuseva to Everyone : No problem, Michael. 21:24:08 From Tea Kuseva to Everyone : We can send out in the follow up email 21:24:19 From Meni Porat to Everyone : Thank you,דרור, גיא ואיתי 21:24:25 From Michael to Everyone : Thanks 21:25:09 From Adrian Mundy to Everyone : Sorry but need to leave, but thanks for very interesting presentation, will catch up with recording. 21:25:26 From Itai Goldstein [Microsoft] to Everyone : You're all welcome. Thanks for the attending, asking questions and giving feedback. We had a great evening. 21:25:46 From Itai Goldstein [Microsoft] to Everyone : Also thanks to Alan and Tea for the invite! :) 21:25:59 From Mourad to Everyone : Thanks everybody 21:26:00 From Alan Murray to Everyone : Thanks Adrian 21:26:17 From Tea Kuseva to Everyone : Thank you, Itai! It’s been great having you with us! 21:26:36 From Ami Azoulay to Everyone : Thanks a lot, very interesting and fascinating - le'hitraot 21:26:39 From Peter Turrell to Everyone : Thanks everybody 21:27:09 From Chris Stevens to Everyone : Many thanks to everyone very useful - signing off from Leeds, UK - will watch the remainder on U tube 21:27:21 From Alan Murray to Everyone : Thanks, Chris 21:27:24 From Mechelle Norton to Everyone : Personally, I would never switch to Fast Ring on a production machine. You must be willing to lose everything and have to reinstall. 21:27:34 From Michael to Everyone : Really interesting 21:27:40 From Tanja Kuhn to Everyone : Thanks everybody 21:27:57 From Alan Murray to Everyone : Great seeing you Tanja 21:28:01 From Eric Lane to Everyone : I get a little lost in SharePoint. Can anyone recommend training for SharePoint? 21:28:03 From Tea Kuseva to Everyone : Thanks everyone! 21:29:27 From Alan Murray to Everyone : Thanks Itai 21:29:35 From bpatterson to Everyone : anybody get locked out of most of the presentation? 21:29:59 From Alan Murray to Everyone : There were some problems Brandon 21:30:08 From Itai Goldstein [Microsoft] to Everyone : >> I get a little lost in SharePoint. Can anyone recommend training for SharePoint?I recommend the courses in LinkedIn Learning. There are so many, focusing on different aspects of the products. Here's a link for SharePoint courses:https://www.linkedin.com/learning/topics/sharepoint?u=3322 21:30:18 From Andreas Thehos to Everyone : Hi Eric, it is different and in some cases better to use SharePoint lists. Maybe we should talk About it another session on this channel 21:32:37 From Faraz Shaikh to Everyone : Can power query access version history ? 21:32:52 From Andreas Thehos to Everyone : Question: When do we get Data from Picture. On my Mac its allways availible. 21:34:32 From Meni Porat to Everyone : Question to Guy, the "father" of PQ:Today while editing PQ, Excel is inaccessible.Will this be resolved in the future? 21:35:13 From Ben to Everyone : Where can we find the replay to this? 21:35:13 From SjoukeNL to Everyone : Thanks very much to The Three MicroTeers! ;) very interesting, but I have to go 21:35:26 From Alan Murray to Everyone : hey Sjouke 21:35:32 From Patrick O'Beirne to Everyone : @Meni could you open the wb readonly in a second Excel instance? 21:36:19 From Hammad Soomro to Everyone : can we get the slides from you n video 21:36:25 From Raj Rawat to Everyone : This meeting was very useful. Loved the Sheet View, @ Mentions and rich Data Types! Few things were too complex for my existing knowledge. 21:36:33 From Artur to Everyone : Will you fix long pahts problem with Excel soon? 21:37:01 From Mechelle Norton to Everyone : Did you mean "paths" limitation on #characters? 21:37:16 From Mechelle Norton to Everyone : I think that's an OS limitation 21:37:17 From Patrick O'Beirne to Everyone : 216 chars path limit 21:37:44 From Artur to Everyone : No, I mean if the file is deep in several folder I can't open it in excel. 21:38:00 From Mechelle Norton to Everyone : exactly, the path gets longer and longer and there is a limitation. 21:38:12 From Faraz Shaikh to Everyone : Just added idea Version history connecter Power Query for Excel https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/42564832-version-history-connecter-power-query-for-excel 21:38:41 From Artur to Everyone : This is especially a problem with onedrive synced folders 21:39:24 From Patrick O'Beirne to Everyone : Artur would a substituted drive letter work for you? 21:39:29 From Alan Murray to Everyone : Yes, slides will be shared in a follow up email, @Hammad 21:40:07 From Alan Murray to Everyone : Make sure you have all RSVP'd to the meetup to receive the email with the files etc. 21:40:10 From Oakley Turvey to Everyone : IntelliSense for LAMBDA user voice:https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/42564667-can-we-please-get-intellisense-for-lambda-function 21:40:40 From Faraz Shaikh to Everyone : How do we compare Microsoft List vs Excel ? 21:41:18 From Mechelle Norton to Everyone : do you mean SharePoint List? 21:41:33 From Artur to Everyone : My company name is very long and it takes lot of chares form the limit 21:41:55 From Mechelle Norton to Everyone : This is old, but... gives you an idea of what one is good for vs. the other. I think SharePoint is meant more for consumption: https://www.sherweb.com/blog/office-365/why-you-should-be-using-sharepoint-lists-instead-of-excel-spread-sheets-and-how/ 21:42:00 From Meni Porat to Everyone : thanks for an enlightening session. 21:42:02 From Faraz Shaikh to Everyone : Yes.. it the same.. but Microsoft Add “Microsoft List” 21:43:01 From Raj Rawat to Everyone : Ok Need to leave now. But very useful features that I can see from a trainer's point of view!! :) 21:43:23 From Artur to Everyone : Tired it already but still I've got problem with data from clients with very long names 21:43:26 From Oakley Turvey to Everyone : You can do a Find (Ctrl + F) for your @Name and then More Options - Comments - Find All 21:43:57 From tempjk to Everyone : any plans to work with icloud drive instead of one drive? 21:44:09 From Alan Murray to Everyone : Thanks, Raj 21:44:18 From Raj Rawat to Everyone : Thank you all for another splendid meeting !! Tia and Alan!! Fabulous job as always. and today's presenter you were all awesome!! :) Take care all. 21:44:31 From Artur to Everyone : Thank you Patrick 21:44:43 From Charles Williams to Everyone : On the Mac is Power Query native on M1 or does it use Rosetta2? 21:45:01 From SSwajanen to Everyone : Where can I watch a replay of this? 21:45:29 From Tea Kuseva to Everyone : https://www.youtube.com/watch?v=Av53vTMyMQ8 21:45:40 From Tea Kuseva to Everyone : This is the link where you can watch the recording 21:45:56 From Tea Kuseva to Everyone : We will share it in the follow up email as well 21:46:07 From Claire Squibb to Everyone : Thanks very much all, I've got to go now. My first Excel Meetup - loved it! 21:46:19 From SSwajanen to Everyone : Thank you. 21:46:19 From Alan Murray to Everyone : Great to see you, Claire. 21:46:26 From Faraz Shaikh to Everyone : Welcome @Claire 21:46:58 From Andreas Thehos to Everyone : Acutalize the Power Query on a Mac WORKS!!! I am happy. It is a 2014 Mini :-) 21:47:55 From Itai Goldstein [Microsoft] to Everyone : Drop off for 2 minutes 21:47:59 From Gerry to Everyone : Thanks Guy Itai Dror and as always Alan and Tea. Bye 21:48:11 From Alan Murray to Everyone : Thanks, Gerry 21:48:16 From Tea Kuseva to Everyone : Thank you, Gerry! See you next time! 21:49:37 From Itai Goldstein [Microsoft] to Everyone : back 21:50:01 From Mechelle Norton to Everyone : Refresh on Mac is fast because the MAC has 24GB RAM and fast I/o processors 21:51:58 From William G to Everyone : Thanks Everyone. My first Excel Meetup. Really enjoyed it and felt I've learned a lot! 21:52:02 From Patrick O'Beirne to Everyone : Is Officescript only at E3 or E5 level or for all? 21:52:16 From Tea Kuseva to Everyone : Thanks, William 21:52:28 From Mechelle Norton to Everyone : Automate is on web version... 21:52:32 From Alan Murray to Everyone : Great William 21:52:43 From Oakley Turvey to Everyone : Gotta go now. Thanks as ever for another great session Alan & Tea and Guy, Itai & Dror 21:52:56 From Tea Kuseva to Everyone : Thank you, Oakley! See you next time! 21:53:09 From Mechelle Norton to Everyone : Yes, thanks so much. Can't wait to play around with these new features! 21:53:15 From Christa Uekötter to Everyone : I say goodbye and thank you to the presenters and the Organisation Team! 21:53:16 From Alan Murray to Everyone : Make sure you are RSVP'd for this event on this page to receive the follow up email of information - https://www.meetup.com/London-Excel-Meetup-Group/events/275721781/ 21:53:26 From Alan Murray to Everyone : Cheers Christa 21:53:40 From Alan Murray to Everyone : Thanks, Oakley 21:53:48 From Faraz Shaikh to Everyone : That will be great ! 21:54:04 From Patrick O'Beirne to Everyone : Must go. TVM Guy, Itai, Dror, Tea, Alan ! 21:54:15 From Alan Murray to Everyone : Cheers, Patrick 21:54:38 From Charles Williams to Everyone : Thanks Guy and everyone, I gotta go … Bye 21:54:39 From Guy Hunkin to Everyone : >> @guy can you give a link for the Office JavaScript tutorial?https://docs.microsoft.com/en-us/learn/modules/intro-office-add-ins/ 21:55:00 From Katrin Marusch to Everyone : Have to leave. Thanks for that great presentation, Itai, Dror and Guy, and as always Tea and Alan! Loved it. Bye 21:55:29 From Itai Goldstein [Microsoft] to Everyone : A recording of a meetup we had on December, including a demo of Office Scripts:https://www.youtube.com/watch?v=ZFjHeis2wN4&t=161s 21:56:36 From Artur to Everyone : Thank you all. Great session. By. 21:56:46 From Naresh Parmar to Everyone : Thank you All 21:56:58 From Cristina to Everyone : Thanks! 21:56:59 From Ilgar Zarbaliyev to Everyone : Bye 21:57:07 From Tea Kuseva to Everyone : Thanks everyone! 21:57:13 From Hanoch to Everyone : Thanks 21:57:29 From George to Everyone : Thanks