Losing reference to table in Excel (Power Pivot)

J

jak82

Board Regular
Joined
Apr 28, 2016
Messages
146
In power pivot we have uploaded a table which has a calculated column in excel, this seems to work ok, but when we try to refresh the data or make a change to a filter or anything it causes excel to crash and lose the reference to the table and its calculated column.

Anyone came across this an is it possible to have a calculated column in PP from excel

Thanks
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
You must log in or register to reply here.

Similar threads

L
  • Solved
DAX: Double or Nested COUNTX() & SUMX()
Replies
6
Views
562
luuk
L
I
  • Question Question
Power Query Data types and excel time format issue
Replies
5
Views
523
Anand Sydney
A
K
  • Solved
DAX median in pivot table for an "almost empty" column
Replies
1
Views
238
Katchi
K
U
  • Solved
Power Pivot - Add calculated column to subtract total from another table
Replies
2
Views
280
UniqueUsername
U
R
  • Question Question
Filter is not applied to a measure in the detail table
Replies
1
Views
161
sanalytics
S

Forum statistics

Threads
1,225,653
Messages
6,186,203
Members
453,340
Latest member
yearego021

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top