Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
470
Using Excel to recalculate removes all existing data connections?
posted

Hi,

I am using this simple code:

                    IO = New FileStream(fp, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite)
                    WB = Workbook.Load(IO, False)

                    WB.Recalculate()

                    WB.Save(IO)
                Catch ex As Exce

The problem is that existing Connections to databases are removed when saving. How can I retain them?

thanks