Difficulty Refreshing / Editing Connections of Source Data

[samgray85]

Hi

Situation:

• I have a working PowerPivot Workbook that imports data from Source.xlsx
• Source.xlsx is getting large and unwieldy. I'd like to change its file format to .xlsb (Save As > Source.xlsb)
• I have saved a new file called Source New.xlsb (identical to Source.xlsx just new file name and extension)

Complication:

• When I go to the PowerPivot window > Home > Edit Connections and try to point PowerPivot from Source.xlsx to Source New.xlsb and attempt to refresh the data it just goes into an infinite refresh loop and eventually crashes.

How do I fix this?

Thanks

Sam

 

[scottsen]

Wow, that is a new one I thought for sure you would say you needed to switch to SQL or something, and that really isn't supported. I really thought your scenario should "just work".

Same data? Like maybe you added rows and finally blew a memory cap and crashed? 32 bit? 64 bit?

 

[samgray85]

That could be a possibility. I am using 32 bit and have had a lot of trouble running out of resources, hence the switch to XLSB.

New rows have been added to Source.xlsx - but this was refreshable. The same data set on XLSB was not refreshable.

I have a 64 bit set up at home so will give that a go.

 

[samgray85]

Wow, that is a new one I thought for sure you would say you needed to switch to SQL or something, and that really isn't supported. I really thought your scenario should "just work".

Same data? Like maybe you added rows and finally blew a memory cap and crashed? 32 bit? 64 bit?

It would appear that 32 bit and RAM was the issue.

I ran the update via my 64 bit setup and tracked the RAM usage through Task Manager - 32 bits / 2 GB cap just could not cope.