Depending on what functions you have running to make it do all the things, could you have it live on Sharepoint and just access it through Excel online? That offloads a lot of the processing to MS’s servers but does have the disadvantage of being Excel Online, which has some but not all the functions of desktop Excel and the keyboard shortcuts may or may not work. Also, Excel Online doesn’t seem to love macros, which can break things.
the only reason that the spreadsheet exist is because of macros (pretty sure the table has over 10.000 lines of VBA, with more in the tables it accesses) but my bosses are thankfully investigating alternatives for a migration of the functions that that table provides.
I sadly am only a trainee at the company, so i don’t get too much input beyond fixing whatever breaks with it every so often while it’s still in use, but yeah.
my boss does appreciate what i’m doing but i just don’t have a decision power that someone working in IT would have (i work in the physics/chemistry lab). thanks though, i appreciate the sentiment :)
Depending on what functions you have running to make it do all the things, could you have it live on Sharepoint and just access it through Excel online? That offloads a lot of the processing to MS’s servers but does have the disadvantage of being Excel Online, which has some but not all the functions of desktop Excel and the keyboard shortcuts may or may not work. Also, Excel Online doesn’t seem to love macros, which can break things.
the only reason that the spreadsheet exist is because of macros (pretty sure the table has over 10.000 lines of VBA, with more in the tables it accesses) but my bosses are thankfully investigating alternatives for a migration of the functions that that table provides.
I sadly am only a trainee at the company, so i don’t get too much input beyond fixing whatever breaks with it every so often while it’s still in use, but yeah.
“Only a trainee…”
Sounds like you’re the only one keeping that thing running. Don’t sell yourself short!
my boss does appreciate what i’m doing but i just don’t have a decision power that someone working in IT would have (i work in the physics/chemistry lab). thanks though, i appreciate the sentiment :)