With that said, the module does work, although it's in a different type of preview screen than how the preview is generally presented.ġ) I'm working from home for the next two days, so it'll be Monday before I get a chance to try a different PC at work with 2013.Ģ) When opening it in Office 365 on my home PC with Windows 10, I get the same results. However, I did some searching and I believe I've been successful in adding a macro that needs to be ran from the developer tab, correct? Anyway, I had to save the spreadsheet as a macro enable *.xlsm file first. Other than having a vague idea of what VBA is, I have no familiarity with it. (depends on whether linked to other sheets etc) if new tab works ok, then may be quicker just to copy the problem sheets and paste to new ones and set up printing afresh What happens if you create a new tab and hit Print Preview? Perhaps created in different versions of Excel? Is there a missing font? The inconsistencies suggest Excel is having difficulties opening Print Preview - but only in certain tabs - so there is something different about those tabs. A few ideas, based on nothing but previous headaches:ġ Open the workbook on a different machine running 2013 - does it behave differently?ģ Are you opening the file via Excel or from Explorer - I remember having occasional crashes occur in print preview (only in one file) and it took me ages to realise that it only happened if I opened the file via Explorer - still no idea why! There are lots of things that can cause a problem with print preview, and many are rather obscure.

Excel 2013 print preview