Powerpivot工作簿不爽快 [英] Powerpivot workbook not refreshing
问题描述
Hi Assistance Team,
我一直试图多次刷新我的工作簿。我检查并重新检查了连接设置和查询,一切都很好。但是,此错误仅显示在一张工作表中。
操作失败,因为源数据库不存在,源表执行不存在,或者因为您无权访问数据源。
更多详情:
OLE DB或ODBC错误:不支持请求的转换..
当前操作已取消因为交易中的另一个操作失败了。
线外对象'DataSource',指的是ID为'323708b7-75b9-41f4-af6a-8fbe40a1a72d',已经指定但尚未使用。
指定了ID为'Temp_DSV'的对象'DataSourceView'已被指定但尚未被指定使用。
这可能是什么原因?
你能帮助我吗? ?
谢谢,
Andrea
嗨Andrea,
感谢您与Microsoft Office Protocols团队联系。
此论坛的目的是支持开放规范文档。您可以从
http://www.microsoft.com/openspecifications/en/us/default .aspx
开放规范文档库可以从
http://msdn.microsoft.com/en- us / library / dd208104(PROT.10).aspx
你的问题可能更适用于这个论坛:
https:// social .technet.microsoft.com /论坛/ en-us / home?forum = sqlkjpowerpivotforexcel
Hi Assistance Team,
I have been trying to refresh my workbook many times. I have checked and recheck the connections setting and the query and It's all fine. Though, this error keeps being shown only for one single sheet.
The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source.
More Details:
OLE DB or ODBC error: Requested conversion is not supported..
The current operation was cancelled because another operation in the transaction failed.
Out of line object 'DataSource', referring to ID(s) '323708b7-75b9-41f4-af6a-8fbe40a1a72d', has been specified but has not been used.
Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used.What could be the motivation for this?
Can you please assist me?
Thank you,
Andrea
解决方案Hi Andrea,
Thank you for contacting Microsoft Office Protocols team.
The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program from http://www.microsoft.com/openspecifications/en/us/default.aspx
The library of Open Specification documents can be accessed from http://msdn.microsoft.com/en-us/library/dd208104(PROT.10).aspx
Your question may be more applicable to this forum:
https://social.technet.microsoft.com/Forums/en-us/home?forum=sqlkjpowerpivotforexcel
这篇关于Powerpivot工作簿不爽快的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文