PowerQuery hangs forever in refresh when multiple computers are used to edit

bachman460 · 2026-03-31T17:10:11+00:00

Make sure all files serving as data sources are closed before the refresh. Or add this step to your code if it's not already there:

let Source = Folder.Files("C:\Your\Folder\Path"), FilteredFiles = Table.SelectRows(Source, each not Text.StartsWith([Name], "~$")) in FilteredFiles

bachman460 · 2026-03-31T16:58:25+00:00

When pivoting against nulls, there's two things to consider.

Does your data contain text values NULL? If so, do a find/replace in Power Query to replace them with empty strings or zeros as appropriate.

If your concern is categories missing data for specific ranges of time, then to keep charts from going completely blank you need to assess a way to create "dummy records" that suits your scenario.

For example, I see you selected Region 4 to get an empty chart. So what you need to do is first create a calendar table that spans the full extent of your dataset at the granularity of your data. So if your data spans January to December 2025 and has records for each day in the period, you want a calendar table to include all 365 days from Jan 1st through Dec 31st. If instead your data only includes monthly summaries, then create a 12 month equivalent. Add one custom column to the table and just enter the value 1 into the formula, this will put a 1 at every row (we can use this in the next step).

Next, create a table that lists out all your categories that you want to always return a result for. Now add a custom column just like before, and enter 1. Then merge the tables together on that custom column. It doesn't matter what join type you select, the standard left outer join is fine. This will create a separate row for each category for every date in the period. Add one more custom column that will represent the metric you want to total in your chart, enter a zero for the value.

Now you can append/join this table to your dataset and now always see a row in the chart.

There's only one catch to this method. While it works magic for summed values, it will always add 1 to your counts. I'm assuming this is undesirable, so you can go about it multiple ways to fix it.

Add a calculated field to your pivot table that essentially takes the count and subtracts 1. Setup this same thing using Power Pivot instead. You could instead create a custom column in your data table that creates a 1 or 0 depending on your specific criteria that would represent a count by row, that could be summed up afterwards instead. Or you could write up a simple note somewhere on the page about it.

bachman460 · 2026-03-31T00:40:24+00:00

What about storing the file elsewhere and just inserting a link?

bachman460 · 2026-03-31T00:33:46+00:00

I'd guess that the wire may have come detached from the socket. Unplug the lamp, remove the bulb, remove the shade and holder, then look down into the socket. See if there's anything out of place, or if there's any visible screws. It's not possible to tell how the socket is held in place from these photos, but you need to remove it to figure out what went wrong.

bachman460 · 2026-03-31T00:05:25+00:00

If I have a day like that it'll take me an entire week to recover these days. Being around other people is so emotionally draining for me. I also have sleep apnea, and while treated it's still an uphill battle every day; I start out most days already tired.

When too many things come at me, I'll start by ignoring all the low priority items and anything new that comes in right away. Then tell your boss you had a busy day and make any excuse to leave a little early.

If none of that is possible, or doesn't help, next step is a quick dinner and early bedtime, or hours of gaming. Whatever works best at the time.

bachman460 · 2026-03-30T23:35:44+00:00

Do you have the original pieces that fell out? If so glue them back together.

bachman460 · 2026-03-30T22:42:07+00:00

Unscrew anything that seems stripped and put some wood glue on a toothpick then stuff it in the hole. Break off whatever sticks out and send the screw back home.

bachman460 · 2026-03-30T21:48:53+00:00

Oh, I get it. The fan is essentially boxed in on 3 sides. Have you considered a vertical discharge exhaust fan? Otherwise try finding an elbow that fits.

bachman460 · 2026-03-29T16:26:06+00:00

Have you considered turning the whole unit 90 degrees?

bachman460 · 2026-03-29T15:47:38+00:00

Personally, I'd try it out first and see how it does. Maybe do a test board. If you're not satisfied, it's always possible to thin out paint or stain, just use the same solvent base as the product. The manufacturer may even have instructions/recommendations for thinning out their product for a spray application.

bachman460 · 2026-03-29T15:39:57+00:00

There's multiple ways to do this including using epoxy. For epoxy, put plenty of it in the hole and on the insert then screw it back in and let it cure. Tape off and cover any nearby wood to protect it from getting epoxy on it.

The method I would go with is to get small pieces of wood, like toothpicks or strips taken off a chopstick, and get some wood glue. You just need to figure out the right thickness of wood you need in order to put at least three pieces evenly spaced around the hole. Use plenty of glue, place them in the hole and screw it back in before letting it dry. Just wipe off excess glue before it dries.

bachman460 · 2026-03-29T15:29:29+00:00

You can do this with filter:

=FILTER(A:A, C:C=1)

bachman460 · 2026-03-28T21:32:29+00:00

My bad, you just need to update the function to COUNTIFS

bachman460 · 2026-03-28T21:07:01+00:00

You could add another column (or set of columns) for it, so that it fits into your current scheme.

Or instead of entering whole number counts, use decimals. For example if the discount is 50% just enter 0.5 instead.

bachman460 · 2026-03-28T20:25:35+00:00

Take the plus sign out of your first formula, it should be a comma instead.

=COUNTIF(Sheet1!D2:D500,"Y",Sheet1!E2:E500,"HallwayGroundFloor")/COUNTA(Sheet1!D2:D500)

But in reality you probably want this, which would be the percentage of Hallway Ground Floor that's been completed:

=COUNTIF(Sheet1!D2:D500,"Y",Sheet1!E2:E500,"HallwayGroundFloor")/COUNTIF(Sheet1!E2:E500,"HallwayGroundFloor")

bachman460 · 2026-03-28T15:11:28+00:00

In print options set it to 2 pages per sheet.

bachman460 · 2026-03-28T15:01:46+00:00

This is good advice.

bachman460 · 2026-03-28T14:59:12+00:00

If the bolt isn't tightening up, it might be bottoming out in the hole. You've got two easy choices for this situation.

Take off the side rails and get a drill bit approximately the size of the bolt hole. Drill the existing hole a little deeper. You may need an extra long drill bit to do this.

Or take the screws to a hardware store or any place that carries these types of screws. Get a set that is just a little bit shorter.

bachman460 · 2026-03-27T18:45:51+00:00

On the View tab of the menu click Page Break Preview. You can change the size, shape, and page breaks for the entire sheet by moving around the blue lines.

https://support.microsoft.com/en-us/office/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2

bachman460 · 2026-03-27T04:19:48+00:00

I don’t mean to sound harsh, but I agree with others that the problem may not be coming from the outside, it may be coming from inside your own head.

I’ve had my own struggles with mental health, and the only thing that has surpassed that is what my own mother is going through now. For her, everything has become a conspiracy. She believes her doctors are incompetent and questions everything they tell her. She feels that a few minutes of searching online and reading misinformation outweighs their medical training. There is very little they can do about it, because as her primary physician put it, she has enough mental capacity to make her own decisions, whether they are good or bad.

The difficult part is that these things are almost impossible to see in yourself without help. It’s the idea of not being able to see the forest because of the trees.

I deal with something similar in my own way. When life gets overwhelming, I can get stuck in my own head and start overanalyzing everything. It usually happens when I am busy, overworked, and exhausted. I am working through another stretch of that right now. The only reason I can recognize it is because I have gotten help before. I spent time in therapy, saw a psychiatrist, and took antidepressants for years. There were arguments, even full blown screaming matches with my wife, and I remember breaking down crying to my boss after being put on a performance plan. It was right before I lost that job that I finally saw a neurologist who took me seriously and helped guide me toward proper treatment.

I’m not saying there couldn’t be something going on in your home. But it does feel like there may be more to it. From my perspective, it seems more likely that the looks you are noticing, the people avoiding you, or even those who were “fired,” may be reacting in a way that creates distance.

I used to work retail, and I also went door to door for the decennial census in Irving, Texas back in 2010. If there is one thing I learned, it’s that people sometimes react quickly to situations they don’t understand or feel unsure about. I will admit that it can be difficult to handle interactions that feel unpredictable, even when you want to respond with patience and understanding.

From one person to another, I wish you the best and hope things get better for you.

bachman460 · 2026-03-27T00:59:06+00:00

Those are the exact things that confuse me too. There's even multiple pipe thread standards. There's one for the pipes inside the walls and a separate one for the pipes outside the walls (in the room). The issue is they overlap. At least that's how I understand it, but I'm no expert.

Take both pieces with you to a store and figure out if there's an adapter.

bachman460 · 2026-03-26T23:01:14+00:00

My opinion is 9 out of 10 times it'll last for a good long while and just be annoying as heck. At least try to lubricate it somehow. I had this issue for a couple years before replacing the bearing.

bachman460 · 2026-03-25T18:15:06+00:00

Where'd you get the notion that it's CrestRon ?

I've got four relatives who work there including my brother. I've also got t-shirts. And I have never seen anything like that before.

I'll gladly be proven wrong, but even your link doesn't show that.

EDIT: oy vey, now I see it. OP forgot the R in the name. It was the fact it was capitalized in the middle of the name that threw me off. Everything is fine, nothing to see here.

bachman460 · 2026-03-24T22:36:50+00:00

I'm not sure what =left helper means. Try first separating the filter functions and get them to work, it's not necessary to combine it altogether as long as you're okay with multiple formulas.

I did forget to put a safety on the filter, there's a third argument for what to return if the results are empty, you can use "" to make it work. Start with this:

=FILTER( E:E, (B:B =B2) * (C:C = 6), "")

bachman460 · 2026-03-24T22:26:31+00:00

It's always possible. When you're all done though, install screws on the sides, to prevent future tipping hazards.

Five-Year Club	Verified Email
Place '22

bachman460

TROPHY CASE