#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
|
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 |
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 |