Recently, changes were made to the frontend that cosists of 2 addtional sheets with about 20 charts and 5 tables. Since this change, I am unable to open the document on the server, but it does open from the access point. Most of the charts do have calculated dimensions. Would this cause any issues.
It sounds like it's a really hard rendering file, but if it opens in the Accesspoint, it seems that some network timeout or something is not allowing you to open the file using Desktop. Anyway, make sure you are leasing a license from the Server if you have not already registered your copy with an standalone license number.
Apart from the above, are you getting some errors?