Issue with .XLSM file type extension and Network path

Feb 17, 2015 at 4:23 PM
Edited Feb 17, 2015 at 11:41 PM
Hi

I want to be able to use also the excel refresher for excel file that contains Macro. when trying it failed
Is this something you can include in a new version?

Another remark
regarding files that are located over the network.
In the Configuration of the service if I add a share name or UNC path it failed. (even when providing an account that have access to the location)

Except of those remarks it works like a charm and it saves me a lot of times
Really nice tool

Thanks already for that :-)
Feb 25, 2015 at 1:23 PM
Hello,

Does the utility work for you with PowerPivot?

For me, it only works with excel. I get the following error with powerpivot

Unhandled Exception: System.ArgumentException: The parameter is incorrect. (Exce
ption from HRESULT: 0x80070057 (E_INVALIDARG))
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFla
gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.OLEDBConnection.get_BackgroundQuery()
at ExcelRefresh.Excel.ExcelUtilities.RefreshAll(Workbook workbook)
at ExcelRefresh.Excel.ExcelUtilities.<>c__DisplayClass4.<RefreshWorkbook>b__3
(Workbook book)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClassa.<UsingWorkbook>b__8(Workboo
k workBook)
at ExcelRefresh.Com.ComHelpers.UsingCOM[T](T reference, Action1 doThis, Acti
on
1 thenFinally)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClassa.<UsingWorkbook>b__7(Applica
tion excelApp)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClass4.<UsingExcel>b__2(Applicatio
n app, Process process)
at ExcelRefresh.Com.ComHelpers.UsingAutomationApp[T](T app, Func2 fnGethWnd,
Action
2 doThis)
at ExcelRefresh.Com.ComHelpers.UsingExcel(Action`1 doThis)
at ExcelRefresh.Excel.ExcelUtilities.RefreshWorkbook(String sourcePath, Strin
g saveToPath, String backupPath)
at RefreshExcel.Program.Main(String[] args)

Any suggestions that would help me sort the issue?

Regards,
Adil
Feb 26, 2015 at 11:03 AM
Hi Adil

For me there is not issue with Powerpivot, i can update using the refresher service without any issue.

My only concern is that this is only working when the XLSX extension.

And also in the configuration you can only use Local folder.

K/R
Feb 27, 2015 at 1:29 PM
Hi,

Thank you for the response.

For me, the utility isnt working with Power Pivot. File extension is .xlsx

It would be great if this is resolved for me. Do you have any suggestions for me to get this working?

Regards,
Adil
Feb 27, 2015 at 8:15 PM
Edited Feb 27, 2015 at 8:17 PM
Hi Adil
first of all my conf:
windows 7 enterprise 64 bits
Office 2013 32 bits

My advise would be to first reinstall the application (maybe run as admin)
  • create a fresh new folder in C:\testexcelrefresher it's just to test
  • configure the application to use this folder
  • copy only one excel file to that folder that contain a powerpivot (to test it's better to try with one :-))
  • make sure the service will have the sufficient power to access the data you want to refresh, for example if the data source is an SQL DB, your account should have access to it.
  • before going ahead go into your excel file and then put the right information in the "Status" field, for this go into excel --> information -->property (show all properties) and then in "Status" set what you want base on the documentation of the website, in my case i'm setting "Always" then each time i'm starting the service then it's updating the file.
  • When all done just run the Service and monitor what going on on the task manager, you should see the service runing and then a excel.exe should run when it will start to update (refresh the file) and when the excel process desappear then this is done you can then stop the service
  • check the file and see if it's ok, if yes you are done :-)
I hope it will help you
Mar 4, 2015 at 2:40 PM
Edited Mar 4, 2015 at 3:03 PM
Hello,
I did some test and the software works also with network path.

Just create a symbolic link like this:

mklink /D C:\Folder\ShareName \\Server\ShareName\Directory

In the excel refresher service configuration browse the local disk and select your "C:\Folder\ShareName", the service will add it in the list as "\\Server\ShareName\Directory".
(done this if you want you can delete the link, you just need it to add the network path inside the refresher config)

Modify the refresher service account user (administrative tools, service...) , using for example a domain account with permissions on the network folder. Restart the service.

Make sure to run excel a first time with the user set in the service, to configure profile and excel firstrun setting etc..

Tested with excel 2013 32bit, win 7 32bit.


P.s.
I noticed that every time you change the refresher service configuration it reset the service user account.
Mar 5, 2015 at 7:29 PM
Hi Psychofab

thanks for the workaround using mklink, i will go ahead and test this from my side.
thanks also for the other info i will make sure service is align with the needed rights to access the different shares path

I will let you know.

Any advice regarding the file type XLSM ?

regards