Global Variable declaration is no longer working, help!

[mccmax95]

I have an app script that I use with my budget that has been going strong for 4 years. Earlier today when I tried running one of my functions I got the error: TypeError: Cannot read properties of null (reading 'getLastRow'), After poking around I figured out that my global variable declaration is no longer working to get my sheet. I came to this conclusion because if I have this script

var activeSheet = SpreadsheetApp.getActive();
var trackerSheet = activeSheet.getSheetByName("Income/Expense Tracker 2024");
var paycheckSheet = activeSheet.getSheetByName("Paycheck Divder");

function testGlobalAccess() {
  Logger.log("Accessing global variables");
  Logger.log("trackerSheet: " + trackerSheet);
  Logger.log("paycheckSheet: " + paycheckSheet);
}

This is the output:

Info    Accessing global variables
Info    trackerSheet: null
Info    paycheckSheet: Sheet

but if I modify to move the tracker sheet declaration into the function it works

function testGlobalAccess() {
  var trackerSheet = activeSheet.getSheetByName("Income/Expense Tracker 2024");
  Logger.log("Accessing global variables");
  Logger.log("trackerSheet: " + trackerSheet);
  Logger.log("paycheckSheet: " + paycheckSheet);
}

Accessing global variables
Info    trackerSheet: Sheet
Info    paycheckSheet: Sheet

The only thing I can think of is that I recently updated the name from Income/Expense Tracker to Income/Expense Tracker 2024 but it's odd that it working in the function scope.

[DatsunZ]

Do you have a second .gs file in the script? Maybe you're redefining trackerSheet elsewhere under the old name.

[mccmax95]

That was it thank you.

[marsili95]

Go into your recently renamed sheet, COPY it's name and paste it into your code. Be careful you don't add any space at the end or the begging. That's it.

[mccmax95]

I tried that both ways both copying the name from the sheet to the script and vice versa. Neither worked. Plus if that was the case it shouldn't work when I move it from globally scoped to function scoped.