Everything was working good. I went into power query and changed a column from "text" to "all" and refreshed the initial problem was fixed. Now no formulas in the entire workbook that reference the table power query imported work. The table name is the same columns are all named the same. How do I fix it. It would take me at least a day to retype all the codes in the workbook.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
All calculations stopped working
- Thread starter cknnugget
- Start date
Excel Facts
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Looked back at the query again column by column. When I changed the formatting in one column, it reverted all the columns to their original format. Once the columns were reformatted everything works correctly
Upvote
0
Similar threads
- Question
- Replies
- 1
- Views
- 151
- Replies
- 0
- Views
- 888
- Replies
- 0
- Views
- 346
- Replies
- 3
- Views
- 2K
