1.0Brainlitter - Inside the mind of Sean Wallbridgehttps://regroove.ca/brainlitterSean Wallbridgehttps://regroove.ca/brainlitter/author/swallbridge/Excel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridgerich600338<blockquote class="wp-embedded-content" data-secret="dsxKBFEAWO"><a href="https://regroove.ca/brainlitter/2017/02/07/excel-online-shapes-break-editing-spreadsheets/">Excel Online – Shapes break editing spreadsheets</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://regroove.ca/brainlitter/2017/02/07/excel-online-shapes-break-editing-spreadsheets/embed/#?secret=dsxKBFEAWO" width="600" height="338" title="“Excel Online – Shapes break editing spreadsheets” — Brainlitter - Inside the mind of Sean Wallbridge" data-secret="dsxKBFEAWO" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
/* ]]> */
</script>
https://i0.wp.com/regroove.ca/brainlitter/wp-content/uploads/sites/2/2017/02/Excel.png?fit=400%2C400&ssl=1400400What A customer recently moved several Excel Workbooks from Google Sheets to Office 365 (and Excel Online). These were complex sheets with lots of linking worksheets, formulas, etc. and on the surface seemed to be fine. However, one weekly operation was to take a copy of an existing worksheet and making it “this weeks” worksheet. …