Microsoft Office products such as Excel and Word have safeguards added that are designed to protect your data from malicious harm. One of these protections is defaulted to not allow you to update your spreadsheets used to pull information from other programs without additional steps. When using, upon opening a file, you may see the following message: Security Warning: Data Connections Have Been Disabled This warning message is disconcerting, annoying, and in most cases unnecessary. While Excel can have active data connections with other files and cloud-based data sources, sometimes there can be old data connections that aren’t necessary. Perhaps at one point you imported a into columns on an existing sheet. That import session may be saved under connections, even though there isn’t actually a dynamic real-time connection to the long-ago-deleted CSV file. Follow these steps to remove unnecessary data connections from Excel files: • Make a backup of your spreadsheet file. • On the Data menu/ribbon click on Connections. A visual of this is below from Excel 2016 for Mac. See the Connections option under the Data tab. • You’ll see a list of current data connections as shown below. How to disable a program from popping up on startup for mac. Remove any that aren’t in use. Keep in mind that this probably won’t have any negative impact, unless you’re using a more complex spreadsheet workbook (like at work) that actually uses active data connections. Notice in the example below, there are no locations in the workbook where the data connection is being used. So, it’s just unnecessary at this point.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. АрхивыКатегории |