Using Excel 2013  with Power Query, odata connection to Project Online to create my data.

I now have a table with additional columns for formulas, and a macro to pick up the users cost constraint before marking each row as Selected or Not Selected. I want to turn track changes on so it's easy to see when items change between selected/not, but it's greyed out.

Any ideas why that would be?

Hi Jessica,

Based on your description, my understanding is that you created a table via Power Query and tried to use Track Change option in Excel, but this option was greyed out.

As far as I know, you can't use Track Change option directly in Power Query, you might be able to write a macro to do this. Or I suggest you export/copy data to Worksheet so that this option can be used in Excel file.

If my understanding is incorrect, please provide more information abnout your issue.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Hi Jessica,

Based on your description, my understanding is that you created a table via Power Query and tried to use Track Change option in Excel, but this option was greyed out.

As far as I know, you can't use Track Change option directly in Power Query, you might be able to write a macro to do this. Or I suggest you export/copy data to Worksheet so that this option can be used in Excel file.

If my understanding is incorrect, please provide more information about your issue.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su