用于自动刷新已关闭的Excel工作簿上的数据连接的宏。 [英] Macro for automatically refreshing Data connection on Closed excel workbook.

问题描述

Hy all。

我需要一些帮助。

我将非常感激，并会为任何帮助祈祷。 

我不知道在Excel中使用宏。

Hy all.
I need some help.
I will be very grateful and will pray-full for any help. 
I don't know about using macros in excel.

我正在使用excel 2013.我有一个工作簿，它连接到SQL Server，用于电源查询和数据透视表。

我希望工作簿中的数据连接可以按特定的时间间隔刷新，并且可以保存工作簿。

有人可以指导我为此添加和启用宏目的。

我完全没有添加宏。所以请有人用一些例子来指导我。

我将非常感谢这一帮助。 

I am using excel 2013. I have a workbook which has connections to SQL Server for power query and pivot tables.
I want that the data connections in work book may be refreshed at specific time intervals and workbook may be saved.
Can some one please guide me for adding and enabling macro for this purpose.
I am completely raw in adding macro. So please someone guide me completely with some example.
I will be very much grateful for this help. 

推荐答案

这是讨论Microsoft Excel功能的问题和反馈的论坛，我会提出你的问题到MSDN论坛for Excel

Hi,

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https：/ /social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的游泳池受访者以及定期阅读论坛的其他合作伙伴可以分享他们的知识，也可以从与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于用于自动刷新已关闭的Excel工作簿上的数据连接的宏。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！