I have an embedded display in an excel workbook. It updates normally but when I print it prints out whatever data from when the workbook was first opened instead of the the last current data. Weird thing is if I go into "design mode" it prints correct current data. However I can't use a macro to print in "design mode".
Overall all objective: Right now we have an excel workbook sent out as a PDF report twice a day. We want to send a PI display as part of the PDF.
This excel workbook is open all shift and designed to be converted to a PDF and emailed from a macro button in excel.