Refreshing a Spreadsheet broke the Formatting Rules and columns that were rearranged

(0) Share

Report

Posted on by Ms-PowerRanger2

108

I'm new to Power Query and have a few questions on what I can and can't do.

I have a spreadsheet that was sent to me and the data is based on a power query.

I performed the following steps on the workbook
added an additional sheet with a lookup table
added some columns where the calculations dealt with workdays and networkdays where the days for the workdays was
located in the lookup table in the other sheet
moved some columns around in the spreadsheet
added some Conditional Formatting Rules

I then sent the spreadsheet back to the owner of the sheet. Upon refresh the spreadsheet broke. The Rules somehow changed what rows they applied to and columns appeared rearranged

Do all the steps mentioned above need to be performed in Power Query?

Can all the steps be performed using Power Query?

If the answer is "Yes", can you give some insight on performing the steps above in Power Query.

Thanks!