Excel Forum

Power pivot - Data doesn't refresh

Frederick Ross

New Member

Members

Forum Posts: 1

Member Since:
July 14, 2020

Offline

July 14, 2020 - 12:31 pm

Hi.

I need help with my Power Pivot. It stopped suddenly to refresh with new data from the tables. When I go into the Power Pivot, the refresh button is unavailable.

The file is here : https://1drv.ms/x/s!AqzbXkWuo9.....A?e=hP8o5q

Basically, I need the new sales on the SORTIE tab to be added to my VENTES ET PROFITS sheet. All my sales after July 11 suddently stopped to be added and all my date can't be refreshed anymore.

Thanks for your help.

Mynda Treacy

Admin

Forum Posts: 4447

Member Since:
July 16, 2010

Offline

July 14, 2020 - 9:59 pm

Hi Frederick,

Welcome to our forum! It looks like the connection between the Excel Table and Power Pivot has been lost. Possibly you renamed the Excel Table VENTE, but Power Pivot maybe knew it as SORTIE?

I'm not sure there's a way to fix it other than to re-import the table and delete the old one, which will also mean rebuilding the relationships and reports.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Shanna Getschel, Lynnette Altomari, Karolis Kmitas, Roy Lutke, Jeff Krueger, Darrell Hodge, Natasha Smith, Sopi Yuniarti

Guest(s) 12

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Sopi Yuniarti

sandra parker

LAFONSO HERNANDEZ

Hayden Hao

Angela chen

Sean Moore

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Forum Stats:

Groups: 3

Forums: 24

Topics: 6214

Posts: 27243

Member Stats:

Guest Posters: 49

Members: 31894

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen