One of the issue came across today while working with smartview, found below in Oracle Forums and Worked for us.
While copying excel sheets, "='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue is line adding up into every row of the sheet in formulas.
Symptom:
User opens a file and has the local HsTbar.xla path embedded at the front of the Smart View Function: "='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue($B$8,"Scenario#"&$....). We also see this if a user opens a file directly from SharePoint, but the embedded path will have the SharePoint server URL in it. As you know, the Smart View function will not work in this state.
Corrective Action:
At this point you should see the imbedded path is gone, allowing you to Refresh as normal. Also, you should be able to Save the file and re-open it without the embedded path from returning.
Thanks,
Madhusudhan
While copying excel sheets, "='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue is line adding up into every row of the sheet in formulas.
Symptom:
User opens a file and has the local HsTbar.xla path embedded at the front of the Smart View Function: "='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue($B$8,"Scenario#"&$....). We also see this if a user opens a file directly from SharePoint, but the embedded path will have the SharePoint server URL in it. As you know, the Smart View function will not work in this state.
Corrective Action:
- In Excel, with the problem file open, go to Data > Edit Links.
- In the Edit Links dialog box, click the Change Source button.
- Browse to where Smart View is installed locally - for us it's C:\Oracle\SmartView\Bin (NOTE: you still need to follow these steps, even if the embedded path is the correct path for the HsTbar.xla).
- Select the HsTbar.xla file and Click OK.
- Click the Close button.
At this point you should see the imbedded path is gone, allowing you to Refresh as normal. Also, you should be able to Save the file and re-open it without the embedded path from returning.
Thanks,
Madhusudhan
Hello,
ReplyDeleteThat solution would probably work, however our files are password protected for audit reasons, therefore we are unable to change source of HsTbar.xla file ("Change Source" button is greyed out in Excel). So, is there are way to prevent SmartView from changing functions in the first place? It does it even though files are password protected and cells containing the Hs functions are locked!
go langaunage training
ReplyDeleteazure training
java training
salesforce training
hadoop training