We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Create XLS with Pivot on the fly

Comments

MeteredOut Posts: 2,967 Forumite

27 March 2024 at 5:23PM edited 27 March 2024 at 5:26PM

DullGreyGuy said:

MeteredOut said:

If the export from the DB is to a known location and file name, have you tried creating a new sheet and referencing the exported sheet as an external sheet?

It could work but not sure having to open two files each time isn't much less clunky than having someone go into the file and manually add either a checking grid or conditional formatting etc but worth considering

In theory, if set up correctly, it should just be a matter of opening the second file (that references the exported file) and refreshing it to update the references. From memory, the references will need the full path to the referenced sheet though, otherwise the file being referenced needs to be open too (that's why I said the export needs to be to a known location/file name).

0

★ ★ ★ Meet your Ambassadors

Confirm your email address to Create Threads and Reply

MSE News

Ofgem proposes new 'no standing charge' Price Cap – but Martin Lewis warns vulnerable customers need to be opted in or it won't work
Ofgem has today launched detailed proposals for a major shake up to its Energy Price Cap that dictates the price over 80% of homes in England, Scotland and Wales pay for their energy bills.
Lloyds, Halifax and Bank of Scotland to cut overdraft rates for millions but hike them for others – here's what's happening and full help
If you're a Lloyds, Halifax or Bank of Scotland current account holder, the interest rate you're charged for using your overdraft could change soon as part of a fees shake-up. The Lloyds Banking Group, which owns all three brands, says millions of its customers will pay less after the changes – but a "few" will pay more.
Warm Home Discount expansion confirmed with millions more eligible for the £150 top-up this winter – here's what we know
Around 2.7 million more low-income households, including 900,000 families with children, will become eligible for the £150 Warm Home Discount this winter, as the Government has confirmed it will remove the existing 'hard to heat' eligibility criteria. The extension has only been confirmed for winter 2025/26, with further changes possible for future years.
Martin Lewis: At last a chance to fix Council Tax flaws impacting millions – debt collection, difficulty challenging your band, discounts and more
Major flaws in the Council Tax system in England could finally be fixed in future, as the Government has launched a wide-ranging consultation to review hideous debt collection practices, the difficulty of challenging your band, the overly complex and horribly-named Severe Mental Impairment discount and more. MoneySavingExpert.com founder Martin Lewis, who has long campaigned on these issues, shares his response and analysis.
Energy complaints to be dealt with more quickly and Energy Ombudsman to get new powers under Government plans
If you have a complaint about your energy firm, it may be resolved more quickly in future, as the Government has announced a raft of proposals to strengthen consumer protections in the energy market. The planned changes include giving the Energy Ombudsman new powers to force firms to comply with its decisions – but it's still very early days. Here's what we know so far.
Warm Home Discount expansion confirmed with millions more eligible for the £150 top-up this winter – here's what we know
Around 2.7 million more households, including 900,000 families with children, will become eligible for the £150 Warm Home Discount this winter, as the Government has confirmed it will remove the existing 'hard to heat' eligibility criteria. The extension has only been confirmed for winter 2025/26, with further changes possible for future years.
Base rate held at 4.25% – here's what it means and when it might be cut next
The Bank of England has held the base rate at 4.25%. Below we explain why, when it might be cut, plus what it means for your mortgage and savings.
Applied for South West Trains 'boundary fares' compensation? Act now to claim it
If you applied for compensation from South West Trains before the deadline in January 2025, you now need to provide your bank details to the claim administrator so it can be paid to you. Here's what you need to know.
Winter Fuel Payments to be reinstated for millions – Martin Lewis explains how it'll work, what it means and if it's an improvement
All State Pensioners in England and Wales will receive a Winter Fuel Payment this winter, though those who earn over £35,000 will see it clawed back through the tax system. It means nine million pensioners will get the £200 or £300 top-up. Here MoneySavingExpert.com founder Martin Lewis shares his instant response and analysis, and we include answers to your key questions.

View All

Create XLS with Pivot on the fly

Comments

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

Get our FREE Weekly email full of deals & guides - and it’s spam-free