none
Update Excel data bindings automatically RRS feed

  • Frage

  • To update Excel data sources I use a self-developed add-in which calls Workbook 1, executes the function RefreshAll() and then makes the file available as PDF.

    That works quite well so far. However, after ~1 minute runtime the window for selecting the data source appears. This window only appears if the stored data source is not available. Which is not the case here.

    Anybody have any idea what might be causing it?

    private void UpdateWorkbook(object sender, EventArgs e)
        {
            var wb = this.Application.Workbooks[1];
            wb.RefreshAll();
            wb.ExportAsFixedFormat(
                Excel.XlFixedFormatType.xlTypePDF, 
                @"C:\Users\phil\Documents\BI\ExcelAddIn\Test.pdf"
            );
        }
    Donnerstag, 16. August 2018 06:53

Alle Antworten

  • Hello Phil795,
    which data source do you use, you didn't specify that.

    This is a German forum, if you speak German please post in German,
    or please post in the international forum.

    regards
    Roland

    Donnerstag, 16. August 2018 09:08