This happens in the background while you work. What are the different refresh options I can set for a data type?Īutomatically every five minutes - At every 5 minute interval, data types with this setting will pull data from the data provider. With manual refresh, you can use Undo to get old data back if needed. This is because the data provider has either determined that the data doesn't update enough to need automatic refresh or they just haven't implemented it yet. Some linked data types can only be refreshed manually. Why do some data types only allow manual refresh? However, background refresh means that you won't be able to use an action like Undo to get back a data type's old data. No. When data types are refreshed automatically, it happens in the background so as not to disturb you. Will refreshing data types automatically disrupt me while I'm working in Excel? The refresh intervals for data types are set by the data provider, but can be changed by following the instructions below. Common questions about data types refresh settings Where does the default refresh interval for a certain data type come from? This does not resolve the issue and means your data may become out of date until you're able to refresh again. In the meantime, if you want to prevent the message from appearing again, you can change the option for the refresh setting to Manually. Tip: If you've seen the "Couldn't refresh data types" message, we recommend you address the issue in the message directly to resolve it.
0 Comments
Leave a Reply. |