Method '~' of object '~' failed and Sheet number 12 does not exist in the workbook

Question

Hi, 
 When I run the sage intelligence report I have this error. 
 Sometimes the error is "Method '~' of object '~' failed" and sometimes is "Sheet number 12 does not exist in the workbook". 
 I can run the report using the user that installed the sage but every other users have this exact same issue. 
 Everyone already has permission to the sage folder and the shared data folder. 
 What is the reason of this? How to make all the user able to run this sage intelligence report? 
 Thank you

Erzsi_I · Accepted Answer

Hello Corinna SBG , Sage 300 support at 1-800-253-1372 will requre a North American Account ID. Typically, international partners are given this number and work with the clients locally in places like Singapore Have you reached out to your partner? They would have helped set up your system. Here's the Contact Resources page for Singapore with some more options.

Gabriela Yates · Answer

I am guessing you are on a setup where you have your main install on one computer or server, and you have other computers that have workstation setup. If this is the case, and you get this error on a standard "canned" report on other workstations, but that same report runs well on computer/server that has the full installation of Sage, then it is likely a setup issue and you need to call Sage Tech Support at 800-253-1372. However, if I have misunderstood your setup, and you are on a single computer, and you are saying when you log into that single computer as the "administrator who installed the software" and the canned report runs fine but when you log in as "another user" on that same computer the canned report errors out, then this is one for your IT staff. It likely has to do with Windows profile permissions and if you originally installed the software as an Administrator.

Sage 300

Method '~' of object '~' failed and Sheet number 12 does not exist in the workbook

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING