July 2023 Update
The Word add-in now supports updating of native charts, not just images of charts.
- Word Charts
- We now have extensive support for updating native charts in the Word add-in. Previously only chart images were supported in the Word add-in. Native charts can significantly reduce .docx file size and reduce transfer size. Chart resolution will never be an issue with native charts.
- Charts are updated based on data in a range, table, or PivotTable (destination-formatted) submitted from Excel
- All chart types are supported: bar, line, area, pie, stock, surface, radar, scatter, tree map, map, sunburst, funnel, histogram, waterfall, and box and whisker charts
- The following chart types are not yet supported with cloud updates (Word and PowerPoint): tree map, map, sunburst, funnel, histogram, waterfall, and box and whisker charts
- It is no longer necessary to append range/table names with "_val". Excel now submits both table values (for charts) and text (for tables) to Word/PowerPoint
- See the "Sample Content" ("Charts" worksheet) on the "Start" tab of the add-in for examples and instructions
February 2023 Update
This update includes sigificant improvements to how PowerPoint documents are linked.
- PowerPoint linking
- We added a new method to link content (shapes) in PowerPoint. So, there are now 2 methods: 'New' and 'Legacy' (Alt-Text-based) methods.
- Both methods will continue to be supported to update documents. So, your existing PowerPoint documents will continue to update the same.
- The New method is significantly easier to use and includes the Link in hidden tags within the shape. The new method can add and list the tags for each shape in the add-in. The new method cannot view the legacy Alt-Text links in the add-in.
- If a shape has both link types, the New method will have priority when performing updates. Older versions of Office may not be able to add/view 'New' links in the add-in, but all systems will be able to perform updates with both link methods (because updates are performed in the cloud, not using the add-in).
- This 'New' method depends on capabilities published by Microsoft in September 2022. If you have an updated Microsoft 365 Office, you should see the 'New' method on the 'Link' tab of the add-in. If you have an older version, then you won't see the new method, but you can continue to use the 'Legacy' method. Supported versions of Office:
- Windows: Version 2208 (Build 15601.20230) or newer
- Mac: 16.64.804.0 or newer
- Office on the web: supported
- Fixed issue related to PowerPoint bulletpoint indents
December 2022 Update
Please try the new features and provide feedback.
Flex tables have become the first choice for linking/updating many types of tables, especially large financial tables.
- Conditional Content (Document Assembly) in Word
- Conditional Content allows you to control what sections to include/exclude in created reports (by deleting un-needed sections) based on formulas/logic in Excel. Conditional content (conditional sections) is similar to Document Assembly.
- For example: if your team creates Word proposals, the Excel workbook and Word template could be configured to only include content applicable to the selected industry, product, region, and configuration selected in Excel
- In Excel, see "Conditional Content" on the "List" tab of the add-in
- In Word, see "Conditional Content" on the "Link" tab of the add-in
- This new version of "Conditional Content" is based on Content Controls and is supported in Word. Previously, there was a very limited version that was based on Bookmarks, but was only supported in Word Cloud updates. The PowerPoint Conditional Content feature is still supported and remains unchanged.
- It is supported in Word add-in updates, as well as all cloud updates (including template-based and API updates)
- If using Conditional Content in the Word add-in, ensure you are updating a copy of your master template. In Word, if content will be deleted, the add-in will ask you to confirm that you want to remove the listed sections
- Direct Transfers (disable content uploads)
- The default method to transfer data from the Excel add-in to the Word/PowerPoint add-in is now 'Direct' in supported systems. Word add-in updates can now be performed without uploading any content.
- Individual users can select "Disable All Content Uploads"
- Business customers can apply a "Disable User Content Uploads" setting that stops the uploading of content of all users.
- See https://analysisplace.com/Resources/Transfer-Method
- "This Sheet Only" Excel Submits
- This option only submits content on the selected worksheet. This has been requested to help simplify management and troubleshooting of links. It also allows users to update only a subset of content; which can reduce transfer size and reduce accumulation of itemPoints.
- By design, Conditional Content is disabled for "This Sheet Only" submits
- Business Fixed "Per-User" subscriptions
- We added "Auto-Purchase". This optionally allows the business to automatically increase the number of purchased credits when needed. For example, if a user was originally assigned a "Standard" tier license, and exceeded the usage limits, Auto-Purchase would automatically upgrade the user to Pro and purchase 2 additional credits from Microsoft AppSource/Marketplace.
- This supplements other existing optional features:
- "Auto-Upgrade": automatically upgrades a user when needed
- "Auto-Activate": automatically assigns a Standard license to a new authorized user. For example, you could allow any user with your "@domain.com" email domain to access the add-in.
- Notifications and Requests: admins can be notified of Auto-Activates, Auto-Purchases, Auto-Upgrades, and requests for upgrades.
- Note that the "Usage-based" (pay-as-you-go) subscription is still the lowest cost and easiest to manage for most organizations.
- These options are configured in the AnalysisPlace Administration Portal for all business accounts.
- Flex Tables - HTML content
- Flex table cells can now contain a wide variety of HTML content
- Examples: make negative numbers red; bold/underline words; add images
- Content can be dynamic (based on logic/formulas)
- Various fixes/improvements to Flex Tables, including adding ability to align tables.
September 2022 Update
This update includes some noteworthy changes, especially the addition of Flex tables (Excel-formatted Word tables)
- Flex Tables (Excel-formatted tables)
- Excel-formatted table updates have been requested by many customers. Flex tables allow updating of Word tables with Excel-formatting.
- Allows for custom formatting (e.g. borders, cell padding, background color, etc.) that can override the appearance of the range in Excel
- Flex tables are better than destination-formatted table for a variety of scenarios, especially financial reports.
- Only compatible with Word (incl. Word Cloud and template-based updates). Flex tables will not work in PowerPoint
- For details, see https://analysisplace.com/Resources/Tables, or just try it.
- It is easy to switch an existing destination table to a flex table (and vice versa). See "Manage Linkable Content" on the Link tab of the Excel add-in. Click "List/Manage Content", select the desired Table or Named Range, then change the "Formatting Control" under "Selected Item" to Flex.
- Management of Linkable Content (Excel)
- This new UI (on the Link tab of the Excel add-in) makes it easier to modify item types and properties. For example, it allows you to switch between Flex tables and regular (Destination) tables
- It replaces adding suffixes (such as _vis, _val, _img) to item names. Existing suffixes will still work fine.
- Allows you to set Workbook default settings that will apply to all individual items that don't have settings applied. For example, you could set default table type to "Flex" -- all new/existing tables (that don't have "Formatting Control" set to "Dest") will become Flex tables. But be aware that this will replace all of those destination-formatted Word tables with Excel-formatted tables when you perform an update.
- Link property settings for range names and shapes are stored with the item and are transferred when the item or sheet are copied to another workbook. Table, PivotTable, and Chart property settings are saved to the workbook and need to be reset if copying to another workbook. All item property settings will remain when moving, renaming, sharing, or copying the workbook.
- Sheet name removal
- The sheet name was removed from the link for most item types. This allows you to change the name of sheets without breaking the link. Broken links that resulted from changing sheet names was a major source of frustration.
- All existing links (with sheet names) will continue to work fine, even if you change the sheet name
- Links of sheet-scoped range names (uncommon) will still contain and depend on the sheet name
- Excel requires that workbook-scoped names and Tables to have unique names. Please ensure that other content (PivotTables, shapes, and charts) have unique names -- if you have multiple shapes with the same name (e.g. "r_Chart1"), only one of them will be used to update content.
- For Cloud updates, ItemPoints are now shown by item, making it easier to understand how total ItemPoints are calculated
- Linking in Word and PowerPoint: you can now filter by sheet or item type or display all items
- Easier resolution of link issues (Word)
- "Show All" now displays all links (which are in Content Controls) in the document and indicates if there is a valid link to Excel content.
- Green: valid link
- Red: source from Excel was not found (perhaps the item was renamed or deleted)
- Gray: no link
- See the Link tab of the Word add-in, under "Appearance of Content Controls"
- Admin Portal: various improvements and fixes were made to the Admin Portal for Microsoft AppSource business customers:
- Ability to change the number of purchased credits from within the portal
- Easier to assign credits (Standard, Pro, Elite tiers) to individual users
- Improved Usage Reports by user, by month, and by API key
- Improved management of user access controls
- More Admin Portal enhancements are coming (Auto Purchase and improvements to Auto Upgrade and Auto Activate)
- Improved ability to generate and manage API keys
- Table corruption issue: fixed issue when re-sizing tables (when rows were inserted in 2 or more tables in the document)
- Cloud updates: Files names with some non-ASCII characters (such as accents) caused the download of the document to fail. This has been fixed using encoding.
- Partial table linking: if user had only a row in a table selected when linking a table, it resulted in cloud update issues (inserted a table in a table) and occasional table corruption. It now links the whole table when only selecting a row. By design, if your selection is within a single cell, it will insert a table within the table cell (nested table). Only the nested table can be linked.