Forms changes the XLSX file name each time (with the number of responses). Why can’t Forms use one of those to let Excel directly import the latest results without manually downloading a file?Ĭonsistent File name PowerQuery can be setup to import the latest version of a source file, but only with the same file name. ![]() Just a few things you’d expect from a proper integration of a Microsoft product with Microsoft Excel and PowerQuery.ĭirect data link Modern Excel has many direct data sources available including seven different types from Microsoft Azure alone. It’s almost as if the Forms and Excel developers haven’t worked together, even though they work for the same company! ![]() The integration between Microsoft Forms and Excel is very poor.
0 Comments
Leave a Reply. |