{"id":7954,"date":"2017-02-07T13:14:17","date_gmt":"2017-02-07T21:14:17","guid":{"rendered":"https:\/\/itgroove.net\/brainlitter\/?p=7954"},"modified":"2017-02-07T13:14:17","modified_gmt":"2017-02-07T21:14:17","slug":"excel-online-shapes-break-editing-spreadsheets","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/","title":{"rendered":"Excel Online – Shapes break editing spreadsheets"},"content":{"rendered":"

What<\/h2>\n

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. It was then linked via formulas to several other sheets. Once this happened however, the next time Excel Online was opened (they use Excel Online vs. Excel 2016 because several people work in the sheet at once), the following would appear and the only workaround was to make a copy (which was no fun at all).<\/p>\n

\"Excel<\/a><\/p>\n

Error Message: To edit in the browser, a copy of the file will be created without the following features: Shapes or other objects<\/span><\/p>\n

\u00a0So What<\/h2>\n

This problem presented itself not at first, but as a new week started and a spreadsheet was copied to become “the next week”. At the core of the problem was that the spreadsheet being used had an object in it that was not visible (And likely there a long time and unnoticed \u2026 or produced somehow in Google Sheets).\u00a0 Finding it at first was not easy.<\/p>\n

\"Finding<\/a><\/p>\n

Now What<\/h2>\n

The trick is to find the little buggers.\u00a0 Here’s how:<\/p>\n

    \n
  1. In Excel (software, not the browser), Click on “Find & Select” and the choose “Selection Pane”<\/li>\n
  2. Press CTRL+G which brings up the “Go To” dialog and then click on the “Special\u2026” button<\/li>\n
  3. Choose the “Objects” radio button and click OK. You will need to do this by the way, for each worksheet<\/li>\n
  4. Identify the objects on the right hand selection pane and delete them (mine were called “AutoShape 14” for example<\/li>\n<\/ol>\n

    That’s it. A pain but once cleaned up, it seemed to do the trick.<\/p>\n

    Here’s a Quick Video on the steps<\/h3>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    What 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. … <\/a><\/p>\n","protected":false},"author":10,"featured_media":7957,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[198,175,8,10,24],"tags":[197,199],"acf":[],"yoast_head":"\nExcel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"What 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. …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-07T21:14:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/\",\"name\":\"Excel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1\",\"datePublished\":\"2017-02-07T21:14:17+00:00\",\"dateModified\":\"2017-02-07T21:14:17+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1\",\"width\":400,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Online – Shapes break editing spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridge","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"Excel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"What 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. …","og_url":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2017-02-07T21:14:17+00:00","og_image":[{"width":400,"height":400,"url":"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1","type":"image\/png"}],"author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/","url":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/","name":"Excel Online - Shapes break editing spreadsheets - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1","datePublished":"2017-02-07T21:14:17+00:00","dateModified":"2017-02-07T21:14:17+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#primaryimage","url":"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1","contentUrl":"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1","width":400,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2017\/02\/07\/excel-online-shapes-break-editing-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Excel Online – Shapes break editing spreadsheets"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/regroove.ca\/brainlitter\/wp-content\/uploads\/sites\/2\/2017\/02\/Excel.png?fit=400%2C400&ssl=1","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/7954"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=7954"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/7954\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media\/7957"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=7954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=7954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=7954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}