Home

Problems adding data to Power Pivot Model

Jean Claude Olivier
Occasional Visitor

Hello,

 

I am trying to bring in data into my PowerPivot model from Excel.  My data looks like this:

 

Date                 Number            Re-model

6/1/20181806049 
6/1/20181806048 
3/1/20181803021 
3/1/20181803022 
3/1/20161603013 
11/1/200412/1/2016

 

If I try to refresh my table in PowerPivot, this will accept,  if I change the last number to 510015

 

6/1/20181806049 
6/1/20181806048 
3/1/20181803021 
3/1/20181803022 
3/1/20161603013 
11/1/20045100152/1/2016

 

I get the error message "We couldn't refresh the connection.  Please go to existing connections and verify they connect to the file or server".  If I replace 510015 with say 2, the refresh does not create an error.

 

Any ideas?  I have tried copying the format down from cells higher above to see if that fixes anything but no luck.

 

Thank you.