Page 1 of 1

Error in GET XLS CONSTANTS

Posted: Fri Feb 14, 2025 2:24 pm
by Ashish_Kumar
I attach a model that I have just started working on and the spreadsheet for inputs. I am using GET XLS CONSTANTS. I can read from the "1. Pop" tab of the spreadsheet but not from the "2. AH" tab. I get the error "Failed to connect to Excel...", for example in the variable "AH share of inpatient services".

There's probably a simple thing I am missing. Help is appreciated.

Re: Error in GET XLS CONSTANTS

Posted: Fri Feb 14, 2025 2:43 pm
by Administrator
The spreadsheet tab name has a space at the end. It's "2. AH ", delete the space at the end and all works fine.

Re: Error in GET XLS CONSTANTS

Posted: Sat Feb 15, 2025 1:25 pm
by Ashish_Kumar
Yes, thanks!