I tried using Firefox and Edge and both have that same error “This item might have been deleted, or expired, or you might not have permission to view it. Contact the owner of this item for more information.”
I was surprised and impressed at how @alan.heatherley published it. From his OneDrive, I downloaded Excel-Calendar-Tiller.xltx and copied that into my workbook. There was no need to futz with data links. Has anyone else tried the XLTX format before?
As for the functionality, the worksheet connected to my local data immediately, but I’m having some issues with the formulas… which are frustrating me because the formulas make sense. For me, only the Other rows (at the bottom of each day) are filling. I can see data in the X:AC area that should be filling into the days but somehow isn’t. The formula makes sense to me but I’m guessing there is something fussy about the filter:
As for the blank days, are the Groups filled in on the left of the calendar? If so, can you double-check that the formulas are pointing at the groups? They should be, but maybe I goofed something when I moved the calendar to it’s own file.
I think the lack of data links are because I used INDIRECT to refer to the Excel tables. I didn’t do it that way for that purpose, but it might be a side-effect. There’s a performance hit for using INDIRECT, so it’s probably not good for big data sets, but I haven’t noticed any issues on my Tiller sheet, but I only have a couple of years worth of data. Maybe someone with more might see an impact. I can optimize the queries further, if necessary.
I don’t think you need the INDIRECT() formulas since Excel has the "Transactions[Date]” functionality to find columns via header references (which Sheets does not). Frankly, I’d remove them. That said, the INDIRECT references aren’t the issue in this case since the data rendered in X:AC via the INDIRECT() references contains the transactions that I’m hoping to see in the calendar, but the formula in H31 (that relies on that data) but does not contain INDIRECT references is failing to pull in the transaction.
I dug into this a little bit more and figured it out… The problem was that, since I had some groups unassigned in my Categories sheet, I was getting VLOOKUP failures in column AC which were faulting the IFERROR() function in the calendar body D:J, resulting in empty cell values.
The easiest solution is to update your formula in X2 to wrap the VLOOKUP with an IFERROR like this: IFERROR(VLOOKUP(INDIRECT($Q$12),INDIRECT($P$14),2,FALSE),””)
I’m seeing some issues with the latest version in OneDrive. My Accounts aren’t loading. There may be other downstream issues but initially it looks like the formulas are broking in T2 and V2. Both are using INDIRECT() references to strings in column Q that no longer exist (Q11 and Q16).
I was able to get past the error message by hitting the “back” navigation in my browser. The shared One Drive version is 6 days old, so I don’t think I have your latest version. Also, it seems my groups are not being recognized as most of the entries flow to “other” instead of the correct groups I chose. Any suggestions?