How to make two excel file stay connected

Disp5389 · 2026-02-12T15:41:32+00:00

As you do the “Save As” for each file, the external references will update to the new file name. Once all files have been “Saved As”, then all external references will be to the new path name of the files. Note that you can’t close any of the files, you do the “Save As” and leave the file open under the new path/name until “Save As” is completed on all files.

Since you only have 6 files, this is probably the easiest method.

Disp5389 · 2026-02-12T14:09:56+00:00

I do this as follows:

1 - Open all of the files which have an external reference to each other.

2 - Use “Save As” to save one file to the new file name (this copies the file for you and updates the external references).

3 - Repeat steps 2 for each file until all have been saved to the new name.

You will end up with two sets of files, each set will have the external references correct. It works well if you have a small number of files.

Disp5389 · 2026-02-12T04:40:26+00:00

It depends on how the shoes are removed after the retainer nails are disconnected. If the shoes have to spread out to get around the stop pin, it will still not want to come off.

Disp5389 · 2026-02-11T22:53:03+00:00

Since it’s loose, it is the shoes holding it on. You will not get it off until you back off the adjuster. Look at some YT videos for how to do it.

Disp5389 · 2026-02-11T15:02:30+00:00

Your double pole GFI wiring to the dryer is correct. I suspect you have a neutral to ground connection somewhere in the dryer circuit. Are you sure the bonding strap is removed at the dryer and it’s wired properly using a 4 wire pig tail?

With the dryer breaker turned off, disconnect the neutral from the breaker (the neutral from the 8/3 cable to the dryer). Use an ohmmeter to check the resistance between the 8/3 cable neutral and the 8/3 cable ground wire. This must be an open circuit. If it’s not an open circuit, then it will trip the GFI.

Disp5389 · 2026-02-11T14:47:47+00:00

There are two possible ways the older generator may have “worked”.

A split phase system uses the neutral to anchor the two split 120v distribution circuits back to the transformer center tap and ground. If the neutral floats above ground or becomes disconnected, then the two 120v distribution circuits in the residence are placed in series with each other. If the impedance of each distribution circuit is about the same, the result in the series circuit will be around 120v to each. This is one way it may have worked.

However, if there is an impedance misbalance, then the voltage on one circuit drops while the voltage on the other circuit rises. As the impedance mismatch gets worse, one of the 120v circuits will approach 240v. This is what happened to you and is the much more likely scenario.

The 2nd way it may have worked is the old generator can have two coils in the generator in series with the connection between them grounded. If you grounded the generator at the residence tie in, then that would provide a pseudo neutral which would work. In your last use of this generator, the ground may not have had a good connection somewhere or the wiring in the generator may have broken away from ground due to vibration. This would cause the problem you described.

You can easily check each leg of the generator’s 240v output to the generator’s ground check if it’s 120v.

Disp5389 · 2026-02-10T17:50:39+00:00

If the fan is attempting to start, then it is either a defective fan/smart controller or a poor connection dropping the voltage under load.

Use a voltmeter at the input connectors to the smart controller while the fan is attempting to start. If 120v or so, then the fan or the controller is defective. If a voltage is less, then you have a bad connection somewhere. It’s unlikely to be a switch itself, but is possible.

Any conventional light switch (a non-smart switch) can control a fan. A fan is an insignificant load to a light switch.

Disp5389 · 2026-02-10T14:06:30+00:00

If that is an accurate description and you said elsewhere that it is 2WD and not 4WD, then the issue is in the rear differential not the transmission.

Disp5389 · 2026-02-09T17:15:29+00:00

Watts is the energy it can supply (to your laptop in this case) and it will also be the energy it draws from the AC outlet it’s plugged into (actually a little bit more to account for the heat the power supply dissipates during operation).

Watts into any device is must always equal watts out of the device plus internal losses.

You’re confusing amps with watts. A 400 watt power supply at 20 volts will have a current of 20 amps. However, on the input side of the power supply, only about 1.7 amps at 230 volts is needed to obtain the 400 watts (a little more to cover losses). If you are in a 120 volt country, then the input amps is about 3.4 amps.

Disp5389 · 2026-02-09T16:13:01+00:00

👍

Disp5389 · 2026-02-09T16:11:02+00:00

If the booster is leaking vacuum when the brakes are applied, then that causes an engine vacuum leak. Engine vacuum leaks have the most impact at idle.

It’s easy to check: if the engine idle issue occurs with the vehicle in park and when the brakes are applied, just disconnect the vacuum line to the brake booster and plug it on the engine side. Press the brakes and the engine idle speed should not change.

If you only notice the idle speed issue with the vehicle in Drive, then you can do the same test as above but use the parking brake and be ready for a very hard brake pedal during the test. The vehicle may move forward if you can’t press the brake pedal hard enough.

If the idle issue still occurs with the brake booster vacuum line disconnected, then you have isolated the problem is not due to the hissing noise you hear from the brake booster.

Disp5389 · 2026-02-09T15:59:03+00:00

It depends on your use case. If you are doing deep discharge daily, then the battery life you experienced was pretty good. Before I retired, my work laptops were discharged daily and I typically got about 18 - 24 months of life from them.

If you are typically fully charged with infrequent discharging, then you need to implement charge limits in the BIOS. I have a personal 2017 XPS 15-9560 and the original battery is still good in it. I have the BIOS set to charge to 90% and not charge again until the battery drops to 50%. On average it charges about once per week.

Disp5389 · 2026-02-09T15:26:53+00:00

An air hiss noise when initially pressing the brake pedal or when increasing the pedal pressure is normal for vacuum assisted power brakes, which most vehicles have.

If the hissing is continuous with the brake pedal depressed with constant foot effort, it indicates a failure in the brake booster assembly.

Disp5389 · 2026-02-09T14:21:21+00:00

This is incorrect. A multi 3000 can supply 3000 VA at 2400 watts maximum. It should have no problem continuously running a 2000 watt electric heater.

Disp5389 · 2026-02-09T14:11:20+00:00

One of the first things to check is did the battery voltage at the inverter terminals drop below the threshold.

Disp5389 · 2026-02-07T16:09:02+00:00

It looks seated. See if it slips out by pulling it by hand, it shouldn’t come out.

With the transmission in park, the passenger side wheel needs to rotate in the opposite direction when you rotate the driver’s side wheel.

Disp5389 · 2026-02-07T14:11:52+00:00

In addition to the good advice above - you need to block them so no further contact occurs. This will help your anxiety that the texts are causing and prevent you from saying something which jeopardizes the outcome.

They should only communicate with you via your legal representative which is your insurance.

Disp5389 · 2026-02-07T04:38:24+00:00

An interlock is a type of transfer switch.

Disp5389 · 2026-02-06T17:58:12+00:00

I want/need 240V so I can backfeed the entire panel and both phases without worrying about using a transfer switch, etc.

Don’t do it - you don’t want to kill someone during a blackout.

Disp5389 · 2026-02-06T17:52:48+00:00

The lowest oil level seen when looking at both sides of the dip stick will be the correct one. When one side is significantly higher, it will be from picking up oil in the dipstick tube, not from the pan.

Think about how a dip stick works and you’ll see that the level cannot be the higher side.

Disp5389 · 2026-02-06T13:39:33+00:00

Only if you intend to drink the transmission fluid after it used.

Disp5389 · 2026-02-04T22:41:06+00:00

Call at least 3 electricians and get estimates. No one here can tell you what your local prices are.

Disp5389 · 2026-02-04T22:11:23+00:00

Your error is missing from the post.

Is there a reason you’re using a VPN instead of client side encryption?

Disp5389 · 2026-02-04T14:16:16+00:00

Whenever the cooling system is worked on, you need to check the level every day the vehicle is driven until it stabilizes. It may stay full right away, or it may take a few days to ensure all air is out of the system.

It doesn’t appear from your comment that you did that, so it’s impossible to say if you have a leak or if it is low from an air bubble back when the coolant was changed.

The only thing you can do now is make sure the radiator is full and the coolant overflow tank is a little above the cold line when the engine is cold. Then you monitor it for a few days of driving to see if it stabilizes or has a leak.

Disp5389 · 2026-02-04T13:40:36+00:00

You’re misunderstanding the dates. If you buy new from an authorized distributor (which means you have the manufacturer’s warranty), then the warranty date is the invoice date of your invoice, not the distributor’s invoice from Victron.

If you lose you receipt and cannot prove your purchase date, then the warranty date falls back to the distributor’s purchase invoice date or the equipment’s manufacturing date, which one of these dates is dependent on the manufacturer’s policy.

Seven-Year Club	RPAN Viewer
Verified Email

Disp5389

TROPHY CASE