Hi there!

I'm currently trying to establish a data connection to an online ICS calendar file. So far, all I've been able to retrieve is the actual text that's in the ICS file, but not the appointments contained within. Unfortunately I don't have the abaility to change the way this calendar is published, so I can't just change it to a CSV or something along those lines. Downloading the file and converting it is not an option since the data changes all the time.

Does anyone know of any solutions to this? Any add-ons that might load the calendar data easily? Or can it be achieved using native excel features?

Thanks in advance!