• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / celMaker 2 (part 2)

Published on April 30, 2009 by David Parker

celMaker 2 (part 2)

My last post was only yesterday, when I released celMaker 2 for Visio 2007 and Excel 2007, but I have already had some feedback from my fellow Visio MVP, John Goldsmith.  He found a couple of “bugs” and suggested an improvement, so they have all been implemented.

Installation

The installation from the web site should be straight forward … if you press the launch link, rather than the install button.

image

The installation adds celMaker2 to your programs under bVisual.

image

You can uninstall using Control Panel.

Note that celMaker2 will automatically check for any updates whenever it is started.

Format as Table option

John suggested that it would be nice to automatically format the data as a table in Excel.

image

So, this option does just that, which means that the headers stay visible, even when scrolled.

image  

Bug Fixes

1. One too many Invisible and Disabled columns

If you used celMaker 2 in the last 24 hours, then you will find Invisible2 and Disabled3 columns … simply delete them

2. Reading Multiple Masters with precedent cells

This resulted in an error because the processing got confused … now fixed

3. Unnamed Connection Point Rows

These were being ignored … now fixed

Please feel free to email me, davidp at bvisual.net with any comments .. they are disabled in this blog because I was getting a lot of Chinese spam.

Related

Filed Under: Visio

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. Ralph Boehm says

    June 2, 2016 at 2:13 pm

    Hi David. I am using Visio 2007 and Excel 2013. I can copy from Visio to Excel but going from Excel to Visio will only remove existing cells. It does not add in anything new or existing from Excel. Any ideas or help?

    Reply
    • davidjpp says

      July 15, 2016 at 3:32 pm

      How are you doing this? Are you using the Database Add-on? When I used to use it in the past, I think that I always ensured that the Excel range included one extra blank row.

      Reply
  2. Ralph Boehm says

    July 20, 2016 at 7:21 pm

    I’m not quite sure I understand what you are asking. I copy from Visio shape into Excel. I insert an Action within the action area. I modify the row for appropriate action then I copy back into the Visio shape. Am I missing the Add On you mention? Is that on Visio side or Excel side? I added a blank row at the end of the Actions in Excel and same results.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Copyright © 2023 · Executive Pro on Genesis Framework · WordPress · Log in