Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2021, 03:46 PM
KatLane KatLane is offline New Data Source for each page in Visio Windows 10 New Data Source for each page in Visio Office 2019
Novice
New Data Source for each page in Visio
 
Join Date: Nov 2021
Posts: 2
KatLane is on a distinguished road
Question New Data Source for each page in Visio

Hi everyone,


I have an Excel spreadsheet with a different sheet for each stage of a process. It was much easier to be able to focus on each stage on its own rather than all in the one process map as it makes changing the links to steps a lot simpler if we need to update a process.


But I want to have a similar set up in Visio, where each page in Visio relates to a separate stage/sheet in my excel process map. Making the charts a lot simpler to follow and acutally readable. Plus I have added the option to click to go to the next process based on the outcome of the previous process as I need this interactive for staff and if they're too complicated no one will use it.



I have copied & pasted the charts I'd done individually into one Visio document which is exactly what I want, but I can't refresh the data in that document to show changes.




Is there a way to set a new data source for each page in a Visio document?


I don't want to have to copy & paste each time if I can help it.


Thank you!
Reply With Quote
  #2  
Old 12-02-2021, 02:46 AM
Guessed's Avatar
Guessed Guessed is offline New Data Source for each page in Visio Windows 10 New Data Source for each page in Visio Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,794
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

I assume this question is talking about the data handling which is present in Visio Professional. Unfortunately I only have Standard so I don't have access to an embedded database to test.

I would presume you need all the data in a single worksheet to import and have it include a field used to filter each page's dataset.

In since I have Visio Standard, I would need to write a macro to build the graphics dynamically - and possibly run that macro from Excel to create the file.

Maybe someone with Visio Professional will chip in here but we don't have many Visio experts on this forum. Have you tried any Visio-specific forums?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-06-2021, 02:49 PM
KatLane KatLane is offline New Data Source for each page in Visio Windows 10 New Data Source for each page in Visio Office 2019
Novice
New Data Source for each page in Visio
 
Join Date: Nov 2021
Posts: 2
KatLane is on a distinguished road
Default

Yes Visio Professional. I'm sorry, I thought this was for Visio. I googled 'visio forum' and this is what came up. I'll keep looking as you're the only reply to date.


Thank you
Reply With Quote
Reply

Tags
data source, pages

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visio 2016 New homemade Shape Data export with Network Shape Data Karlderxte Visio 1 08-17-2021 04:04 PM
New Data Source for each page in Visio Adding new data to data source for Letter emk_24 Mail Merge 4 11-27-2019 05:29 PM
MS Visio 2013 vertically centre data in a shape after deleting all other data Belachenko123 Visio 1 11-24-2015 09:42 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft