Take advantage of the New Economy.
In order to access Sage company data from Excel it is necessary to gain access to the necessary ACCOUNTS folder for the company. In a network environment it is likely that the Sage data resides on a central server. The ACCOUNTS folder under such circumstances needs to be set up as shared read-write.
When in Excel the Sage button will give an option to select a company. There is a drop-down that retains companies that have been previously selected. To select a new company there is a Browse button to search for the ACCOUNTS folder and the SETUP.DTA file.