Nov 13 2023 12:25 AM
Nov 13 2023 12:25 AM
Hi, my first post, I am using an older version of excel, professional plus 2016, windows 10.
(If you wonder why I am still using win 10, I have an i7 processor with 16gb ram, 1Tb hard drive, 4gb graphics card and when I try to install win 11, I am told my laptop can't deal with win 11. For some unknown reason, my processor is missing from the approved list ).
There are 5 numbers in my main sheet corresponding to Mon - Frid, they change every week.
I have a sheet for each week of the year. I used the formulas =SUM(WeeklyTotals!$D2) =SUM(WeeklyTotals!$E2) etc.. to copy these numbers to a sheet called week 1.
I want the copied numbers to be fixed. At the moment, when I change the weekly totals to week 2 for sheet 2, they change in sheet 1/week 1.
Any help would be appreciated.
Nov 13 2023 05:06 AMSolution
In your scenario, it seems like you want to lock in or freeze the values from one sheet onto another without them updating when the source changes.
Here is a way to do that in Excel 2016:
Using the 'Paste Special' method (copying values) or inputting direct cell references on each target sheet would ensure that the values are fixed and not linked to the original cells. This way, changes in the original sheet won't affect the values in the specific weekly sheets.
About Windows 11…
It's unfortunate that your hardware isn't listed as compatible for the Windows 11 upgrade. The Windows 11 system requirements include specific hardware specifications that the system must meet for the upgrade.
However, there might be a few reasons why your i7 processor isn't showing as compatible:
If your hardware doesn't meet the requirements and you're unable to upgrade, Windows 10 is still a fully supported operating system with ongoing security updates until October 14, 2025. It might be worth considering staying with Windows 10 until you plan for a system upgrade or replacement that meets Windows 11 requirements. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Nov 14 2023 07:49 PM
Nov 14 2023 08:59 PM
Thank you for your feedback…
If your laptop's processor is not on the approved list for Windows 11, it means that Microsoft has determined that your device may not meet the minimum requirements for the new operating system. The processor you mentioned, the Intel Core i7-6500U, is from the 6th generation (Skylake) of Intel processors.
While the specific reasons for excluding certain processors can vary, Windows 11 has stricter hardware requirements compared to Windows 10. Some features and security enhancements in Windows 11 may rely on hardware capabilities that are not present in older processors.
If you want to explore further or if there are specific features in Windows 11 that you would like to use, you may consider checking for any updates from Microsoft or reaching out to their support channels for the latest information. Additionally, keep an eye on any announcements regarding changes to the system requirements for Windows 11 in the future.
I wish you much further success.