How do i enable "Remove data from the external data range before saving the workbook"?

Question

How do i enable "Remove data from the external data range before saving the workbook"?

Anonymous

I have a connection, connect to Tabular database(SSAS),

I need use feature "Remove data from the external data range before saving the workbook", but it unavailable,

How do I enable it?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi Jacky,

Welcome to Microsoft Office Community and thank you for posting the question.

As you need assistance in enabling the option Remove data from the external data range before saving the workbook since you have connected to tabular database, post your query in Excel IT Pro for better suggestion:

http://social.technet.microsoft.com/Forums/en/excel/threads

If you have any query and issues with Office suites and office related products, reply and we will be happy to assist you.

Thank You

Share via

How do i enable "Remove data from the external data range before saving the workbook"?

0 additional answers