When doing ""Save as Spreadsheet"" it suddenly is making me select a location on my computer to physically save it?Never had to do this before

I would be looking for the download settings. Generally the default settings would be to automatically download it to your downloads folder. One can change that folder or to have the browser ask each time. Hope that helps.