Excel Track Changes greyed out

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?

July 13th, 2015 1:28am

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

Free Windows Admin Tool Kit Click here and download it now
July 13th, 2015 10:55pm

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

July 14th, 2015 2:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics