Application screenupdating not working in excel 2016
It is saving the workbook before mailing it with a date/time stamp. Excel will automatic update the reference number to Outlook when you open your workbook in a higher version of Excel/Outlook but not update it when you open it in a lower version of Excel/Outlook.
After the file is sent the workbook will be deleted from your hard disk. With Late Binding as I used in the macro examples you not have this problem.
They may already be off in which case I guess it should check first?
I have searched this forum but not come up with anything.
The tips and ideas you find here are designed specifically for users of Excel 2007, Excel 2010, and Excel 2013.
You can sign up for the newsletter by using the simple sign-up form at the right side of this page or any page on the Excel Tips website.
I’ve written earlier tutorials about this topic, but I have had to change sequences of steps in the protocol because more recent versions of Excel were not as flexible with order of operations as Excel 2003 (RIP).
Because Excel can do so much, it helps to discover what others are doing with the program and get real, "hands-on" information about things you can do. (If you need help with other versions of Excel, visit the Excel Tips site.) In addition, we publish a free weekly newsletter called (appropriately enough) Excel Tips.
To fill under or between XY series, we’ll make use of this same approach: XY data on primary axes, Area data on secondary axes, with a secondary date axis.
Let’s start with the simple case of filling color below an XY plot.
Simple data, simple chart of type Scatter With Straight Lines and Markers.
We need to do some calculations to produce data for the area chart series (see below).