Absent Member.
Absent Member.
1948 views

Excel and using external datasources

Hi,

I've encountered an issue where our users have an excel workbook, and has used another excel document as an external datasource.
Is it possible to use that update function through vibe in any way?

I haven't been able to find any documentation, and i tried adding the path of the vibe desktop client folder as the source, but it doesn't seem to work.

Hope someone can help.

Regards
Labels (1)
Tags (2)
0 Likes
2 Replies
Absent Member.
Absent Member.

Oxyprime,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

Has your problem been resolved? If not, you might try one of the following options:

- Visit http://www.novell.com/support and search the knowledgebase and/or check all
the other self support options and support programs available.
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.novell.com)

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.novell.com/faq.php

If this is a reply to a duplicate posting, please ignore and accept our apologies
and rest assured we will issue a stern reprimand to our posting bot.

Good luck!

Your Novell Forums Team
http://forums.novell.com


0 Likes
Absent Member.
Absent Member.

Found the solution to this in case anyone else needs the info.

This is if your document already had another excel file as a source.

Go to your vibe site, find the excel file you are going to use as a external data source.
Press File actions -> press WebDAV URL and copy that link.

Go to the excel workbook which needs the data and change the source to the WebDAV URL, then you can update the workbook.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.