Sometimes you find hierarchy from excel end does not match modeler end.
It could be because of cache in pcFinancials / EFP is not updated.
To update manually, you can follow below:
- Open exel and login -> write down URL to SQL DB end -> close excel
- Go to your PC and browse to C:\Users\UserName\AppData\Roaming\Callisto\pcDATA_xxx (UserName should be the one you use to login to pcFinancials / EFP; AppData folder could be hiden.)
- Delete pcDATA_xxx from above folder.
- Open excel, you can find the saved URL to SQL DB server and user name, pw are all gone. Re-type (or copy/paste) -> login again.
- You will reload all new changes / update everything from SQL server.