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.


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


The installation adds celMaker2 to your programs under bVisual.


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.


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


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.

Posted in Visio. 3 Comments »

3 Responses to “celMaker 2 (part 2)”

  1. Ralph Boehm Says:

    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?

    • davidjpp Says:

      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.

  2. Ralph Boehm Says:

    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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query


Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

%d bloggers like this: