Perhaps a certain section of your spreadsheet never printed or the spreadsheet took too many pages to print. Maybe it printed in portrait mode when it should’ve printed landscape. You’ve just sent an Excel spreadsheet to your printer, but when you check it, you discover that the spreadsheet didn’t print right. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Printing Microsoft Excel spreadsheets can be tricky, but you can avoid most printing problems by following these tips. PPS.How to Print from Microsoft Excel & Avoid Printing Problems
See attached for the spreadsheet (with sensitive info removed) Funnily enough though, if I copy a sheet to a new spreadsheet, I can access all of the aforementioned features.ĭoes anyone have an explanation and how to fix this? I REALLY don't want to try to copy the stuff in my sheets across to a new one. In addition to this, all of my ActiveX buttons and text boxes have disappeared from the sheets, and my list data validated cells no longer bring up a drop down menu, and don't accept any valid strings (when I enter a string from the list that it's using, it just comes up with "This is not valid, Try again") If I create a new spreadsheet, they are no longer disabled? but the functionality is disabled for all sheets in the spreadsheet. The following functions are disabled / greyed out: In one particular spreadsheet I have lost the ability to use lots of functionality in the Ribbon. I've come across something bizarre in Excel 2010.
0 kommentar(er)
