MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 266|Reply: 4

Refresh Visio Excel data

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 9-14-2016 18:32:30 | All posts |Read mode
Hi all,
I used the Viso wizard to create an org chart from Excel data, which worked really well.  If I subsequently discover an odd piece of the source data needs changed is it possible to refresh?
Cheers, Avendi





[b]
Last edited by avendi; 05-03-2016 at 05:27 AM.









Reply

Props Report

6

Topics

473

Posts

1104

Integral

King

Rank: 6Rank: 6

Integral
1104
Post on 9-14-2016 18:52:39 | All posts



Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-gene...xcel-data.html
Thread Closed.
Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-6-2017 16:45:31 | All posts



the simple formula












Reply Support Opposition

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-6-2017 18:20:16 | All posts



What is the source of the #VALUE# error? My first thought would be to nest the current function in B so that it returns some kind of text string when it errors, then the sum function ImramBhatti suggested would work fine. Are you familiar with the IFERROR() function? https://support.office.com/en-us/art...6-63f3e417f611
Something like =IFERROR(current formula in B,error)











Reply Support Opposition

Props Report

14

Topics

436

Posts

1026

Integral

King

Rank: 6Rank: 6

Integral
1026
Post on 2-6-2017 19:27:54 | All posts



This is inappropriate language. Further offenses will result in a ban.

Common courtesy is the order of the day. Avoid coarse language, personal attacks and inflammatory remarks. Address your concerns at topics and not at people.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:26 , Processed in 0.180402 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!