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
Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
- Replies
- 0
- Views
- 672
- Replies
- 0
- Views
- 325
- Replies
- 3
- Views
- 1K
- Replies
- 4
- Views
- 413
