Sharing link with 'Anyone with the link can view' option still prompts anonymous users to login.

wolfie42 --

I ran into this exact problem a couple of years ago, and decided it is way too much work trying to import into Microsoft Project an Excel workbook that was exported from Project for the Web. However, if this something you absolutely have to do, then copy all of the cells from the exported Excel workbook (including the column names) and then paste them into a competely new Excel workbook. Then save the new workbook. You should now find that the information appears as expected in the Import dialog in Microsoft Project. Hope this helps.