![excel 2016 live preview excel 2016 live preview](https://cdn.ablebits.com/_img-blog/paste-special/copy-values-paste-special.png)
![excel 2016 live preview excel 2016 live preview](https://www.globaledulink.co.uk/wp-content/uploads/2018/04/Microsoft-77-727-Microsoft-Office-Excel-2016-Live-Practice-Lab-150x500.jpg)
![excel 2016 live preview excel 2016 live preview](https://www.physiciansweekly.com/wp-content/uploads/2012/06/Obesity-Among-Adolescents-Chart.png)
I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result. I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc. I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me. I have uninstalled the addin and so far so good, but I cannot categorically say that this was the cause.ĭoesn't seem to cover the issue I describe
Excel 2016 live preview code#
The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. Some days I can work without this problem, other days I encounter this 2 or 3 times. I can't work out when it goes into this mode. Clicking save just invokes the same msgbox again. If I close the workbook I am prompted to save, close without saving or cancel. Using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File') Found others suffering the same but haven't found any conclusive answer yet.Įvery so often when I attempt to save a file, (including save as), Excel won'r let me.