ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data connections in Excel (https://www.excelbanter.com/excel-programming/423267-data-connections-excel.html)

swtupr

Data connections in Excel
 
Hi,
I have 4 data connections in 4 sheets of a workbook, each of which is
connected to other excel sheet on sharepoint. When this workbook is mailed to
other user, some how 2 of the connections are lost and data doesnt get
refreshed. Is there something to do with Excel settings on the users machine
or did any one face this issue with Excel 2007 before?
Expecting replies ASAP.

Thanks in Advance.

swtupr

Data connections in Excel
 
Is there a way to change the excel settings to limit the number of data
connections for a workbook in Excel 2007?

"swtupr" wrote:

Hi,
I have 4 data connections in 4 sheets of a workbook, each of which is
connected to other excel sheet on sharepoint. When this workbook is mailed to
other user, some how 2 of the connections are lost and data doesnt get
refreshed. Is there something to do with Excel settings on the users machine
or did any one face this issue with Excel 2007 before?
Expecting replies ASAP.

Thanks in Advance.


swtupr

Data connections in Excel
 
Any update on this????

"swtupr" wrote:

Is there a way to change the excel settings to limit the number of data
connections for a workbook in Excel 2007?

"swtupr" wrote:

Hi,
I have 4 data connections in 4 sheets of a workbook, each of which is
connected to other excel sheet on sharepoint. When this workbook is mailed to
other user, some how 2 of the connections are lost and data doesnt get
refreshed. Is there something to do with Excel settings on the users machine
or did any one face this issue with Excel 2007 before?
Expecting replies ASAP.

Thanks in Advance.



All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com