ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Disabling some MS Excel warnings. (https://www.excelbanter.com/excel-discussion-misc-queries/2800-disabling-some-ms-excel-warnings.html)

Christopher Blue

Disabling some MS Excel warnings.
 
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?


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com