Disabling some MS Excel warnings.

[Christopher Blue]

I have a .xls file that presents a graph from an external .csv file. I have
it set to refresh the external data automatically on reopening the .xls file.
It works fine for the most part but Excel gives me two warnings everytime I
use the file that annoy me:

1. Upon opening the .xls file, Excel gives me a warning about how automatic
refreshes can be malicious and forces me to select whether to enable them or
not.

2. Upon exiting, Excel prompts me with a save dialog. It is true that the
data changes (I have it set to clear the external data on close so the .xls
file takes up less space) but I have the graph setup just how I want it so I
honestly don't need Excel to ask me if I want to save it with the new numbers
from the csv each time. Is there a way to disable this? Or perhaps, to have
the graph's source come directly from the .csv file so its all relative?

[jamesorces]

Hi have you figured out the issue?

[AliGW]

The thread is very nearly 20 years old.

Start your own thread if you need help with a similar problem, please.