DATA REFRESH CONNECTION NO LONGER WORKING

%3CLINGO-SUB%20id%3D%22lingo-sub-41996%22%20slang%3D%22en-US%22%3EDATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41996%22%20slang%3D%22en-US%22%3E%3CP%3EI%20normally%20insert%20the%20excel%20spreadsheet%20into%20OneNote.%20When%20I%26nbsp%3Bopen%20the%20spreadsheet%20in%20excel%20the%20'add-in'%20data%20refresh%20connection%20is%20now%20missing.%20So%20I'm%20unable%20to%20refresh%20the%20data%20and%20see%20new%20responses.%20I%20have%20to%20go%20back%20to%20the%20online%20form%20and%20reopen%20and%20resave%20the%20form.%20In%20excel%20the%20add-in%20is%20still%20present%20under%20'my%20add-ins'%20but%20when%20selected%20it%20has%20no%20effect%20on%20the%20form.%26nbsp%3B%20What%20am%20I%20doing%20wrong!%20please%20help%20as%20I%20had%20this%20working%20fine%20last%20week%2C%20something%20has%20changed%20since%20the%20new%20features%20came%20out.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-41996%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153113%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153113%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20not%20mean%20to%20be%20rude.%26nbsp%3B%20This%20is%20really%20bad.%26nbsp%3B%20By%20today%2C%20it%20has%20actually%20broken%20solutions%20we%20did%20have%20in%20place%2C%20it%20alters%20projects%20we%20had%20moving%20forward%2C%20and%20there%20is%20nothing%20in%20release%20%5Bfor%20us%5D%20to%20mitigate%20the%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-88053%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-88053%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F67494%22%20target%3D%22_blank%22%3E%40evandern%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20message%20is%20possibly%20in%20the%20wrong%20thread%2C%20space%20and%20community.%20You%20should%20ask%20this%20question%20at%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3EExcel%20community%3C%2FA%3E%26nbsp%3Bin%20the%20appropriate%20space.%20First%20check%20if%20anyone%20else%20has%20experienced%20the%20same%20problem%20you%20have.%20If%20not%2C%20then%26nbsp%3Bstart%20a%20new%20conversation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20one%20thing%20you%20can%20check%20is%20your%20data%20source%20of%20the%20Pivot%20Table.%20For%20example%2C%20if%20the%20data%20source%20is%20from%20A1%20to%20D100%20and%20you%20add%20more%20information%20below%20row%20100%2C%20the%20refresh%20will%20not%20work%20because%20the%20data%20is%20excluded%20from%20your%20pivot%20table%20data%20source.%20Just%20check%20the%20options%20in%20the%20ribbon%20while%20you%20are%20active%20in%20the%20Pivot%20Table%2C%20one%20of%20them%20should%20refer%20to%20the%20data%20souce%2C%20check%20that%20and%20expand%20it%20if%20necessary.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20time%20you%20can%20ask%20your%20question%20in%20the%20Excel%20community.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-87930%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-87930%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20continuing%20document%20in%20excel%20that%20I%20work%20on%20daily.%20%26nbsp%3BI%20am%20trying%20to%20refresh%20my%20pivot%20table%20and%20when%20I%20hit%20Refresh%20All%20the%20data%20that%20I%20would%20like%20updated%20and%20refreshed%20is%20not%20working.%20I%20hope%20I%20am%20asking%20my%20quetion%20correctly.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-72574%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-72574%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Pickerell%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGreat%20question.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20release%20a%20new%20expereince%20for%20Excel%20survey%20in%20OneDrive%20for%20Business%20and%20Excel%20Online%2C%20and%20rename%20to%20Forms%20for%20Excel%20%2C%20which%20will%20help%20you%20create%20questions%20in%20Microsoft%20Forms%20and%20get%20real-time%20response%20in%20your%20Excel%20workbook%20in%20your%20OneDrive%20for%20Business.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20feature%20is%20under%20rolling%20out%20in%20O365%20EDU%2C%20and%20it%20will%20take%20weeks%20for%20global%20deployment.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20you%20could%20enjoy%20the%20new%20expereince.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EZhongzhong%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-72550%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-72550%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7646%22%20target%3D%22_blank%22%3E%40Zhongzhong%20Li%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20updates%20as%20to%20when%20a%20native%20data%20sync%20from%20Forms%20to%20Excel%20might%20be%20coming%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-43719%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-43719%22%20slang%3D%22en-US%22%3E%3CP%3EBTW%2C%20the%20data%20sync%20add-in%20should%20still%20work%20in%20exisiting%20Excel%20workbook%2C%20but%20in%20not%20new%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-43715%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-43715%22%20slang%3D%22en-US%22%3EThank%20you%20for%20letting%20me%20know%2C%20When%20will%20the%20new%20data%20sync%20be%20ready%20as%20I%20have%20lots%20of%20Forms%20that%20were%20reliant%20on%20the%20old%20data%20sync%3F%20Thanks%20Liz%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-43684%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20REFRESH%20CONNECTION%20NO%20LONGER%20WORKING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-43684%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Liz%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20retired%20the%20data%20sync%20%22Add-in%22.%20We%20are%20working%20on%20several%20new%20features%2C%20include%20native%20data%20sync.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EZhongzhong%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I normally insert the excel spreadsheet into OneNote. When I open the spreadsheet in excel the 'add-in' data refresh connection is now missing. So I'm unable to refresh the data and see new responses. I have to go back to the online form and reopen and resave the form. In excel the add-in is still present under 'my add-ins' but when selected it has no effect on the form.  What am I doing wrong! please help as I had this working fine last week, something has changed since the new features came out.

Thank you

8 Replies
Highlighted

Hi Liz,

 

We have retired the data sync "Add-in". We are working on several new features, include native data sync.

 

Regards,

Zhongzhong

Highlighted
Thank you for letting me know, When will the new data sync be ready as I have lots of Forms that were reliant on the old data sync? Thanks Liz
Highlighted

BTW, the data sync add-in should still work in exisiting Excel workbook, but in not new file.

Highlighted

@Zhongzhong Li,

 

Any updates as to when a native data sync from Forms to Excel might be coming?

Highlighted

Hi Pickerell,

 

Great question.

 

We release a new expereince for Excel survey in OneDrive for Business and Excel Online, and rename to Forms for Excel , which will help you create questions in Microsoft Forms and get real-time response in your Excel workbook in your OneDrive for Business.

 

The feature is under rolling out in O365 EDU, and it will take weeks for global deployment.

 

I hope you could enjoy the new expereince.

 

Regards,

Zhongzhong

 

 

Highlighted

I have a continuing document in excel that I work on daily.  I am trying to refresh my pivot table and when I hit Refresh All the data that I would like updated and refreshed is not working. I hope I am asking my quetion correctly. Thank you.

Highlighted

Hello @evandern

 

Your message is possibly in the wrong thread, space and community. You should ask this question at the Excel community in the appropriate space. First check if anyone else has experienced the same problem you have. If not, then start a new conversation.

 

However, one thing you can check is your data source of the Pivot Table. For example, if the data source is from A1 to D100 and you add more information below row 100, the refresh will not work because the data is excluded from your pivot table data source. Just check the options in the ribbon while you are active in the Pivot Table, one of them should refer to the data souce, check that and expand it if necessary.

 

Next time you can ask your question in the Excel community. :)

Highlighted

I do not mean to be rude.  This is really bad.  By today, it has actually broken solutions we did have in place, it alters projects we had moving forward, and there is nothing in release [for us] to mitigate the problem.