Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2022, 11:27 AM
alaskaboxers alaskaboxers is offline Changing location of Excel Data Source in Visio Professional Windows 10 Changing location of Excel Data Source in Visio Professional Office 2021
Novice
Changing location of Excel Data Source in Visio Professional
 
Join Date: Dec 2022
Posts: 1
alaskaboxers is on a distinguished road
Default Changing location of Excel Data Source in Visio Professional

I am passing my very large (300+ employees) Visio Org Chart to another supervisor. I am moving the location of the data source since it is currently on my One Drive. Nothing else is changing except where I am storing the data.



BUT, the org chart freaks out and looks nothing like it is supposed to but not sure why. All of the data is EXACTLY the same, just a different file path.

Can someone provide some insight. I feel like there is something I am missing. I don't know why it works perfectly right now but not when I just move the file to another location on the network.
Reply With Quote
  #2  
Old 12-12-2022, 03:09 PM
Guessed's Avatar
Guessed Guessed is offline Changing location of Excel Data Source in Visio Professional Windows 10 Changing location of Excel Data Source in Visio Professional Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I would guess that perhaps your second machine is running a different version of Visio or perhaps has different options set.

Does the page re-organise consistently in the same way if you run this macro?
Code:
Sub ArrangeMyOrg()
  Application.AutoLayout = True
  With ActivePage
    .PageSheet.CellsSRC(visSectionObject, visRowPageLayout, visPLOResizePage).FormulaForceU = "TRUE"
    .PageSheet.CellsSRC(visSectionObject, visRowPageLayout, visPLOAvenueSizeX).FormulaForceU = "7.5 mm"
    .PageSheet.CellsSRC(visSectionObject, visRowPageLayout, visPLOLineRouteExt).FormulaForceU = "1"
    .Layout
  End With
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visio 2019 Professional GeekDad Visio 1 04-11-2022 05:43 PM
New Data Source for each page in Visio KatLane Visio 2 12-06-2021 02:49 PM
RefreshAll data source Excel from Word As1900 Word VBA 0 08-31-2021 09:19 AM
Changing location of Excel Data Source in Visio Professional Merge same excel data source in two columns Marcia Mail Merge 1 07-25-2019 02:27 PM
Automatically changing Excel source after a folder change philippe.delobbe Word Tables 0 04-29-2015 01:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 AM.


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