Excel flashing when using table write

[Mike_Weber]

I'm monitoring 100 channels or so of data and would like to use Excel as the display. Using the "table write" vi, in the excel specific reports addon causes Excel to flash on every update.  Updates take place every second so it's pretty irritating.  The "text write" vi is too slow to use.  Is there some way to use the table write vi without Excel flashing on every update?  I tried the excel command Application.ScreenUpdating = False  in a macro in my template but that doesn't do anything.

Thanks, Mike

[nathand]

No personal experience with this, just putting an idea out there - can you try setting ScreenUpdating within your LabVIEW code?

[ben64]

Hard to tell without seeing your actual VI but my guess is that you are using the Excel Easy Table.vi in a loop. If you open the diagram of this vi you will see that there is a subVI called Set Report Font.vi in it, so for each iteration of your loop this subVI is reformatting the report font. That is probably what causes the blinking that you see. As a possible workaround you can create your own version of this vi without the Set Report Font function (note: it is a bad idea to try to modifiy directly the toolkit vi).

Ben64

[Mike_Weber]

Nathand, not sure how I would do that.  I was using the "run macro"" vi in the toolkit.  Ben, I'll give that a try when I get back to work Monday.  Sounds promising  Thanks to you both

[nathand]

---

@Mike_Weber wrote:

Nathand, not sure how I would do that.  I was using the "run macro"" vi in the toolkit.

---

There's an Excel Get ActiveX References VI under the Excel specific functions in the Report Generation Palette.  From there you can get the application reference.  Put a property node on it and you can set the ScreenUpdating property.