Last seen: Jun 27, 2026
Hi Charlie, Please attach your file containing the formulas. This file is all values. Thanks, Mynda
Hi John, I usually just do it by eye, but you could try removing the title and then adding back in again. Copy your title text first so you can pas...
Glad you got it working, Steve. Hopefully Phil will write a post soon on how to use VBA to format all of the series in one go. Mynda
Hi Elinor, Thanks for sharing your file. If you were to put your data into a single table and add a column for the Week number, you could then use ...
Hi Charlie, See file attached. Note: time on 23/10/18 does not meet your criteria of arriving before 8:15 and leaving after 16:30. Also, I inser...
Hi Charlie, Please see file attached. Note: some of your information doesn't tally with the example. Specifically I can't get 6.72 net work hour...
Hi Steve, It's because your source data for the PivotTable is not in a tabular format. If you look at my source data you'll see there are 3 columns...
Hi Bax, Maybe you can record a macro to do it, otherwise there is mention of cleaning the custom xml data in the document inspector, but I'd take a...
Hi Bax, If you want to retain the data the query placed in the worksheet but disconnect the table from the query and remove it, then you'll want to...
Hi Anne, I'm not sure I understand the data structure, but I wonder if there is a circular reference in the query e.g. the query gets data from all...
Logical data types are TRUE and FALSE. Maybe you have a column containing these values? I'm sure your boss will be thrilled if you can automate the...
Hi Mardi, Glad you found a workaround. It sounds like the change type step is the cause of the errors in the Date and Time columns. I usually set t...
Hi Mardi, If you remove the 'Change Type' step (it's usually the second step), do the errors disappear? Mynda
Hi Charlie, Please see file attached. Note: some of your information doesn't tally with the example. Specifically I can't get 6.72 net work hour...
Hi Jeanie, I'm wondering why you think there is a volume issue with having all of the queries in the same workbook? There is no data limit with Pow...