Forum Discussion
What causes an excel file to 'Show Print Preview' rather than show the preview by default.
I've figured out what was causing it.
I did play around with clearing cell formatting and using inquire etc aswell, as to your suggestion. The document was only about 7 pages to start, but after that I decided to start coping elements over to another blank excel file until it would reproduce the 'Show Print Preview' issue on that file, and I found what was causing it.
I suspect that the person who made this document, converted their table from another format, as all the cell lines, even though they adhered to formatting, also had shape lines drawn on them, they were hiding across the whole doument, but I didn't see them until I started copying it over to the other document.
I had to Press F5 - > select Special, - > Objects, - > OK and press delete to clear the whole document of these shapesThis meant the show print preview button cleared and the preview went back to normal, and now the document runs through the flow correctly!
I suspect that the excel render engine gets overloaded perhaps with too many shapes, and the conversion tool might rely on the that part to be working to convert the document to PDF, but at least we found the solution, which means the Power Automate OneDrive convert file does not keep failing with error 429 "Alert: Your operation has been throttled." from it retrying to convert the file so many times that it gets shut down.
Thanks for your help
My guess - Show Print Preview icon appears if we have 2084 or more pages to print. Perhaps depends on layout, but in any case around 2000 pages.
If in such workbook we delete extra data decreasing number of pages to print, let say to one page, above icon still appears. Perhaps info is kept in some cache, not sure. However, if to clear ranges with deleted data (Home -> Clear on selected range; or Inquire -> Clean Excess Cell Formatting) the icon is not shown on Print Preview.
At least that's what I was able to reproduce.
I've figured out what was causing it.
I did play around with clearing cell formatting and using inquire etc aswell, as to your suggestion. The document was only about 7 pages to start, but after that I decided to start coping elements over to another blank excel file until it would reproduce the 'Show Print Preview' issue on that file, and I found what was causing it.
I suspect that the person who made this document, converted their table from another format, as all the cell lines, even though they adhered to formatting, also had shape lines drawn on them, they were hiding across the whole doument, but I didn't see them until I started copying it over to the other document.
I had to Press F5 - > select Special, - > Objects, - > OK and press delete to clear the whole document of these shapes
This meant the show print preview button cleared and the preview went back to normal, and now the document runs through the flow correctly!
I suspect that the excel render engine gets overloaded perhaps with too many shapes, and the conversion tool might rely on the that part to be working to convert the document to PDF, but at least we found the solution, which means the Power Automate OneDrive convert file does not keep failing with error 429 "Alert: Your operation has been throttled." from it retrying to convert the file so many times that it gets shut down.
Thanks for your help