Home

Excel spreadsheets published online no longer allow copy/paste more than one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-364306%22%20slang%3D%22en-US%22%3EExcel%20spreadsheets%20published%20online%20no%20longer%20allow%20copy%2Fpaste%20more%20than%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364306%22%20slang%3D%22en-US%22%3E%3CDIV%3EI%20use%20Excel%20spreadsheets%20published%20and%20shared%20on%20personal%20Websites%20(with%20permissions%20to%20use%20formulas%20without%20saving%20data).%20This%20allows%20me%20to%20share%20formulas%20without%20modifying%20the%20spreadsheet.%26nbsp%3B%20Until%202%20month%20ago%2C%20it%20was%20possible%20to%20save%20several%20rows%20and%20columns%20(in%20local%20excel%20or%20other%20spreadsheets)%20and%20paste%20them%20back%20into%20a%20published%20online%20excel%20to%20continue%20the%20work.%20Thus%20it%20was%20possible%20to%20paste%20data%20from%20different%20rows%20and%20columns.%20Now%20it%20is%20only%20possible%20to%20do%20this%20in%20the%20user's%20online%20environment.%20In%20the%20published%20ones%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Eit%20is%20only%20possible%20to%20copy%20and%20paste%20in%20a%20cell%3C%2FSTRONG%3E%2C%20requiring%20in%20addition%20click%20on%20it%20(before%20only%20control%2BV%20is%20needed).%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CP%20class%3D%22%22%3EThe%20sheet%20is%20embedded%20with%20Interaction%20permissions%20for%3A%3C%2FP%3E%3C%2FDIV%3E%3CUL%3E%3CLI%3E%26nbsp%3BAllow%20users%20to%20sort%20and%20filter%20data%3C%2FLI%3E%3CLI%3EAllow%20users%20to%20write%20to%20cells%20(their%20changes%20will%20not%20be%20saved)%3C%2FLI%3E%3C%2FUL%3E%3CDIV%3E%3CP%3EI%20add%20a%20gif%20animation%20with%20a%20real%20example%20I%20just%20created%20to%20reproduce%20the%20error.%20To%20the%20left%20embedded%20in%20a%20personal%20web%20and%20to%20the%20right%20in%20online%20editing%20mode%20in%20onedrive.%20The%20behavior%20of%20the%20online%20spreadsheet%20was%20similar%20for%20both%20environments%20(online%20vs%20embed)%20until%20two%20months%20ago.%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20in%20the%20case%20of%20the%20left%20(embedded)%20it%20is%20not%20possible%20to%20paste%20the%20copied%20table%20as%20it%20was%20before%20and%20if%20it%20is%20still%20possible%20in%20the%20online%20environment.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EHas%20this%20problem%20been%20detected%3F%20Is%20there%20a%20planned%20solution%3F%3C%2FDIV%3E%3CDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2Fad07f69d-95e8-4ba7-831f-ccb186c6e8d7%3Fupload%3Dtrue%22%20border%3D%220%22%20alt%3D%22Image%22%20%2F%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364306%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
userErnesto
Frequent Visitor
I use Excel spreadsheets published and shared on personal Websites (with permissions to use formulas without saving data). This allows me to share formulas without modifying the spreadsheet.  Until 2 month ago, it was possible to save several rows and columns (in local excel or other spreadsheets) and paste them back into a published online excel to continue the work. Thus it was possible to paste data from different rows and columns. Now it is only possible to do this in the user's online environment. In the published ones, it is only possible to copy and paste in a cell, requiring in addition click on it (before only control+V is needed).

The sheet is embedded with Interaction permissions for:

  •  Allow users to sort and filter data
  • Allow users to write to cells (their changes will not be saved)

I add a gif animation with a real example I just created to reproduce the error. To the left embedded in a personal web and to the right in online editing mode in onedrive. The behavior of the online spreadsheet was similar for both environments (online vs embed) until two months ago. 

Now, in the case of the left (embedded) it is not possible to paste the copied table as it was before and if it is still possible in the online environment.

 
Has this problem been detected? Is there a planned solution?

 

Thanks!

Image

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies