Make Win11 save all Excel data before it automatically shuts down the laptop ?!


GeneralLee01

Member
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
Hi All,

I work (not work work, but private) a lot with a 27 GB spready sheet in Excel. I have a up to date subscription on Microsoft 365 and use the fill off my own SSD drive.

Often I run out of power and miss that message, so Win11 goes pooooooof, and the screen is black. Also I sometimes close the laptop lid by mistake.

Now how do I make sure that in these cases Win11 properly saves all data and files automatically ?

I am kind of fed up with all these damaged Excel files I have all the time.

Thanks
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

glasskuter

Well-known member
Power User
VIP
Local time
6:28 AM
Posts
1,872
Location
The Lone Star State of Texas
OS
Windows 11 Pro 21H2 22000.778
AutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers that saves your file automatically, every few seconds, as you work. AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
 

My Computers

System One System Two

  • OS
    Windows 11 Pro 21H2 22000.778
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Optiplex 7080
    CPU
    i9-10900
    Memory
    32 gb
    Monitor(s) Displays
    Benq 27
    Screen Resolution
    2560x1440
    Hard Drives
    256 m.2 2230-256+1 tb hdd
    PSU
    500w
    Case
    MT
    Cooling
    Dell Premium
    Keyboard
    Logitech wired
    Mouse
    Logitech wireless
    Browser
    Firefox
    Antivirus
    Defender+MWB Premium
  • Operating System
    Windows 10 Pro 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Optiplex 9020
    CPU
    i7-4770
    Memory
    24 gb
    Screen Resolution
    2560x1440
    Hard Drives
    256 gb Toshiba BG4 M.2 NVE SSB and 1 tb hdd
    PSU
    500w
    Case
    MT
    Cooling
    standard
    Mouse
    Logitech wireless
    Keyboard
    Logitech wired
    Antivirus
    Defender+MWB Premium

jimbo45

Well-known member
Power User
VIP
Local time
11:28 AM
Posts
1,647
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi All,

I work (not work work, but private) a lot with a 27 GB spready sheet in Excel. I have a up to date subscription on Microsoft 365 and use the fill off my own SSD drive.

Often I run out of power and miss that message, so Win11 goes pooooooof, and the screen is black. Also I sometimes close the laptop lid by mistake.

Now how do I make sure that in these cases Win11 properly saves all data and files automatically ?

I am kind of fed up with all these damaged Excel files I have all the time.

Thanks
Hi there
Not the answer to the original question but it seems to me that using the "Work Smarter not Harder" type of option youi might be better to re-organise that EXCEL workbook into a load of separate linked workbooks with linked worksheets in these too.

To me a 27GB EXCEL book sounds as if it's just begging also to be converted into some sort of database with a load of tables etc.

If you use these sorts of methods you only have a single screen in focus where updates in the other workbooks would be carrieds out automatically and quickly.

Without knowing the data fields and the project required it's difficult to give examples but I just get the gut feel that the whole thing could be re-arranged. I've a big background in complex enfginnerring projects etc and make a lot of use of spreadsheets and I would certainly baulk at the idea of a 27 GB EXCEL workbook. !!!

I believe also power options in Windows can give you "Actions on closing Lid" somwhere - or equivalent -- I'm on a Linux laptop at the moment but I'm sure Windows has the identical options somewhere equivalent to these:
Screenshot_20220406_085004.png

Setting to Sleep / Hibernate (not sure of the Windows terminology) should also work to close down gracefully and re-start at next boot OK..



Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

cereberus

Well-known member
Pro User
VIP
Local time
12:28 PM
Posts
2,033
OS
Windows 10 Pro + others in VHDs
AutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers that saves your file automatically, every few seconds, as you work. AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
Autosave has been around for years but
Hi All,

I work (not work work, but private) a lot with a 27 GB spready sheet in Excel. I have a up to date subscription on Microsoft 365 and use the fill off my own SSD drive.

Often I run out of power and miss that message, so Win11 goes pooooooof, and the screen is black. Also I sometimes close the laptop lid by mistake.

Now how do I make sure that in these cases Win11 properly saves all data and files automatically ?

I am kind of fed up with all these damaged Excel files I have all the time.

Thanks
Although as @glasskuter says, you should ensure autosave is on , you should change your power options.

In advanced power options (need to access via old control panel), you should change the action that closing the lid does to "hibernate".

You can also set critical alerts etc to say 10% rather than 2% (defaullt) to give you more time.

You can also set action on low power to shutdown rather than do nothing - I think this will tell you if app is stil open, as it tries to close down, and you can abandon the shutdown.

Also, by far the most important point is to remember the first two golden rules of computing.

Golden Rule 1 - Always save data regularly.

Golden Rule 2 - If any doubt, refer back to Rule 1.

Why do you not just connect to mains?

Another option is to consider a UPS which will provide a few minutes extra backup.
 

My Computer

System One

  • OS
    Windows 10 Pro + others in VHDs
    Computer type
    Laptop
    Manufacturer/Model
    ASUS Vivobook 14
    CPU
    I7
    Motherboard
    Yep, Laptop has one.
    Memory
    16 GB
    Graphics Card(s)
    Integrated Intel Iris XE
    Sound Card
    Realtek built in
    Monitor(s) Displays
    N/A
    Screen Resolution
    1920x1080
    Hard Drives
    1 TB Optane NVME SSD, 1 TB NVME SSD
    PSU
    Yep, got one
    Case
    Yep, got one
    Cooling
    Stella Artois
    Keyboard
    Built in
    Mouse
    Bluetooth , wired
    Internet Speed
    72 Mb/s :-(
    Browser
    Edge mostly
    Antivirus
    Defender
    Other Info
    TPM 2.0

Berton

Well-known member
Member
VIP
Local time
5:28 AM
Posts
678
Location
Wyoming
OS
Win11 Pro RTM x64
Also check Options, Save and settings therein, my Excel 15/Office 2013 allows AutoRecovery that can be adjusted as to how often.
 

My Computers

System One System Two

  • OS
    Win11 Pro RTM x64
    Computer type
    Laptop
    Manufacturer/Model
    Dell Vostro 3400
    CPU
    Intel Core i5
    Memory
    8GB
    Hard Drives
    256GB SSD NVMe
  • Operating System
    Windows 11 Pro RTM x64
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Vostro 5890
    CPU
    Intel Core i5
    Memory
    16GB
    Graphics card(s)
    Onboard, no VGA using DisplayPort-to-VGA adapter
    Monitor(s) Displays
    21"
    Hard Drives
    512GB SSD NVMe, 2TB WDC HDD
    Browser
    Firefox, Edge
    Antivirus
    Windows Defender/Microsoft Security

wiganken

Member
VIP
Local time
12:28 PM
Posts
32
Location
UK
OS
Windows 11 Pro
Often I run out of power
I am kind of fed up with all these damaged Excel files I have all the time.
Do you not have a battery power level indication icon at the bottom right hand side of your screen in the 'Notification area'? I thought all laptops show this by default. If you operate on battery power only it is essential that you glance at this regularly (every 20 - 30 minutes?) and maybe hover the mouse cursor over it to see what %ge power is left. It takes less than 5 seconds to do this and, if the power is low (20%) then recharge the battery.

If you must operate on battery only then get into the habit of checking the remaining power level regularly.

As @cereberus suggests, could you not work whilst connected to the mains?
 
Last edited:

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    PC/Desktop
    Manufacturer/Model
    HP EliteDesk 705 G5
    CPU
    AMD Ryzen 5 Pro 3400GE
    Memory
    8GB DDR4 SDRAM
    Graphics Card(s)
    Integrated AMD Radeon Vega 11
    Hard Drives
    256 GB PCIe NVMe M.2 SSD
  • Operating System
    Windows 11 Home
    Computer type
    Laptop
    Manufacturer/Model
    DELL Inspiron 15-3576
    CPU
    Intel Core i5-8250U
    Memory
    8 GB DDR4 - 2400 SODIMM
    Graphics card(s)
    Intel UHD Graphics 620
    Hard Drives
    256GB SK Hynix SC311 SATA SSD

Try3

Well-known member
Power User
VIP
Local time
12:28 PM
Posts
573
Location
The proper part of London
OS
Windows 11 Home x64 Version 21H2 Build 22000.739
Now how do I make sure that in these cases Win11 properly saves all data and files automatically ?
You can set the critical power action to hibernate so that you have the files back as soon as you power up [on AC] afterwards.
Do test your critical battery level to make sure it is useful. As batteries age you can find that you need to increase the level because the way Windows treats it is quite dumb.
You can also consider not using battery power unless it is necessary. Every time you use your battery you are using up part of its life.

I sometimes close the laptop lid by mistake.
You can change that in Power options to Do nothing or to Hibernate.

27 GB spready sheet in Excel
I agree with the others that this seems risky. Only you know your requirements so I can only advise considering other options:
- Convert the whole lot to MS Office Access or another database. As I think you do not have MS Office Access in your 365 subscription, you could ask the other contributors for recommendations [I only know Access].
- Restructure the spreadsheet so it is, as mentioned above, a collection of separate workbooks rather than a single mammoth one.


Best of luck,
Denis
.
 

My Computer

System One

  • OS
    Windows 11 Home x64 Version 21H2 Build 22000.739

Wynona

Well-known member
Power User
VIP
Local time
6:28 AM
Posts
1,442
Location
Arkansas
OS
Windows 11 20000.613
Hi All,

I work (not work work, but private) a lot with a 27 GB spready sheet in Excel. I have a up to date subscription on Microsoft 365 and use the fill off my own SSD drive.

Often I run out of power and miss that message, so Win11 goes pooooooof, and the screen is black. Also I sometimes close the laptop lid by mistake.

Now how do I make sure that in these cases Win11 properly saves all data and files automatically ?

I am kind of fed up with all these damaged Excel files I have all the time.

Thanks
When I have something in Microsoft 365 active, and shut down the computer, it's still there when I reboot.
 

My Computers

System One System Two

  • OS
    Windows 11 20000.613
    Computer type
    PC/Desktop
    Manufacturer/Model
    HP Envy TE01-1xxx
    CPU
    ntel(R) Core(TM) i7-10700 CPU @ 2.90GHz 2.90 GHz
    Motherboard
    16.0GB Dual-Channel Unknown @ 1463MHz (21-21-21-47)
    Memory
    16384 MBytes
    Graphics Card(s)
    Intel UHD Graphics 630
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Monitor 1 - Acer 27" Monitor 2 - Acer 27"
    Screen Resolution
    1920 x 1080
    Hard Drives
    WDC PC SN530 SDBPNPZ-512G-1006 (SSD)
    Seagate ST1000DM003-1SB102
    Seagate BUP Slim SCSI Disk Device (SSD)
    PSU
    HP
    Case
    HP
    Cooling
    Standard
    Keyboard
    Logitech Wave K350
    Mouse
    Logitech M705
    Internet Speed
    100 mbps
    Browser
    Firefox
    Antivirus
    Windows Defender
    Other Info
    That's all Folks!
  • Operating System
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    HP
    CPU
    Intel Core i7 (10th gen) 10700
    Motherboard
    Intel
    Memory
    16 GB
    Graphics card(s)
    Intel UHD Graphics 630
    Sound Card
    Built-in
    Monitor(s) Displays
    Acer 27" & Samsung 24"
    Screen Resolution
    1920 x
    Hard Drives
    SSD (512 GB)
    HDD (1 TB)
    Seagate
    PSU
    Intel i7 10th Generation
    Case
    HP
    Cooling
    HP/Intel?
    Mouse
    Logitech M705
    Keyboard
    Logitech Wave K350
    Internet Speed
    50 mbps
    Browser
    Firefox 90.2
    Antivirus
    Windows Defender
    Other Info
    Headphone/Microphone Combo
    SuperSpeed USB Type-A (4 on front)
    HP 3-in-One Card Readr
    SuperSpeed USB Type-C
    DVD Writer

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
AutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers that saves your file automatically, every few seconds, as you work. AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
Hi GK, thanks for the reply. It is a huge spreadsheet so enabling Autosave and Autorecalculate slow down the work so much that it must be disabled. Also I think that even with Autosave I will end up with a damaged file in case I run out of power.
 
Last edited:

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
Hi there
Not the answer to the original question but it seems to me that using the "Work Smarter not Harder" type of option youi might be better to re-organise that EXCEL workbook into a load of separate linked workbooks with linked worksheets in these too.

To me a 27GB EXCEL book sounds as if it's just begging also to be converted into some sort of database with a load of tables etc.

If you use these sorts of methods you only have a single screen in focus where updates in the other workbooks would be carrieds out automatically and quickly.

Without knowing the data fields and the project required it's difficult to give examples but I just get the gut feel that the whole thing could be re-arranged. I've a big background in complex enfginnerring projects etc and make a lot of use of spreadsheets and I would certainly baulk at the idea of a 27 GB EXCEL workbook. !!!

I believe also power options in Windows can give you "Actions on closing Lid" somwhere - or equivalent -- I'm on a Linux laptop at the moment but . . . . . . . . .

Good morning Jimbo, thanks for the suggestions. creating linked workbooks will be a lot of work. Also checking the integrety of the resulting information in the workbooks might be a nightmare. The workbook has a few dozen sheets, the main sheet about 100000 rows with about 15 columns. The other sheets have standalone information or information calculated from this main sheet. At the moment all works fine and I am happy with it. There are millions of calculations so enabling automatic calculations (as you propose) will bog down the whole thing too much.

I will look in to the power options. I think I need to improve / adjust those settings.
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
Autosave has been around for years but

Hi Cerebus. Unfortunately Autosave and Autorecalculkate bogs down the system too much.

In advanced power options (need to access via old control panel), you should change the action that closing the lid does to "hibernate".

You can also set critical alerts etc to say 10% rather than 2% (defaullt) to give you more time.

Will look in to power options for the lid. How do I make Win11 save all files before shutting down when the power is getting too low ?


You can also set action on low power to shutdown rather than do nothing - I think this will tell you if app is stil open, as it tries to close down, and you can abandon the shutdown.

Nope, at the moment it warns me at 20% , but when I miss, or ignore, or have to do something else (non computing) first that Win11 goes pooooooof a "while" later.

Also, by far the most important point is to remember the first two golden rules of computing.

Golden Rule 1 - Always save data regularly.

Golden Rule 2 - If any doubt, refer back to Rule 1.

Not sure why you think I do not do that. Problem is that one steeds need to compare the damaged excel file to the latest saved file and determine which one still has the highest data integrity and then fix that one and include the missing data again.

Why do you not just connect to mains?

That is a weird question. :) Of course I do connect to the mains, how else can I recharge the battery.

Another option is to consider a UPS which will provide a few minutes extra backup.

You are kidding, connecting a UPS to a laptop :)
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
Also check Options, Save and settings therein, my Excel 15/Office 2013 allows AutoRecovery that can be adjusted as to how often.

Hi Berton. Will do, perhaps I can tweak something. Problem is that saving all (saving without calculation) takes about 1 minute. So is really intrusive and has a huge impact on my work flow. And of course with autosave my problem is not solved, I still end up with a damaged file when the system runs out of power.
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
Do you not have a battery power level indication icon at the bottom right hand side of your screen in the 'Notification area'? I thought all laptops show this by default.

Thyanks for the reminder WG. Yes I do, I have a fairly modern laptop.


If you operate on battery power only it is essential that you glance at this regularly (every 20 - 30 minutes?) and maybe hover the mouse cursor over it to see what %ge power is left. It takes less than 5 seconds to do this and, if the power is low (20%) then recharge the battery.

If you must operate on battery only then get into the habit of checking the remaining power level regularly.

As @cereberus suggests, could you not work whilst connected to the mains?

Yep, am aware of that. Of course all that does not help when I need to leave my laptop and it runs out of power when I am not there.
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

z3r010

Administrator
Staff member
Local time
12:28 PM
Posts
1,978
Location
Worsley, Manchester, UK
OS
Windows 11 Workstation
That's far too big of a file to be using in safely excel, honestly, you should look about transferring it all into some sort of database.
 

My Computers

System One System Two

  • OS
    Windows 11 Workstation
    Computer type
    PC/Desktop
    Manufacturer/Model
    doofenshmirtz evil incorporated
    CPU
    Ryzen 9 5950X
    Motherboard
    Asus ROG Crosshair VIII Formula
    Memory
    Corsair Vengeance RGB PRO Black 64GB (4x16GB) 3600MHz AMD Ryzen Tuned DDR4
    Graphics Card(s)
    ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    Sound Card
    Sound BlasterX Katana
    Monitor(s) Displays
    3 x27" Dell U2714H & 1 x 34" Dell
    Hard Drives
    Samsung 980 Pro 1TB M.2 2280 PCI-e 4.0 x4 NVMe Solid State
    Drive
    PSU
    ASUS ROG THOR 850W 80 Plus Platinum
    Case
    ASUS ROG Strix Helios Midi-Tower ARGB Gaming Case
    Cooling
    ASUS ROG Strix LC Performance RGB AIO CPU Liquid Cooler - 360mm
    Keyboard
    Logi Ergo
    Mouse
    Logitech MX Master 3
    Internet Speed
    900/100 Mbps
    Browser
    Chrome
    Antivirus
    Windows Defender, Malwarebytes Pro
    Other Info
    HP M281 Printer
    Logitech Brio Stream webcam
    Yeti X mic
  • Operating System
    Windows 10
    Computer type
    Laptop
    Manufacturer/Model
    Surface Laptop
    CPU
    i7

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
You can set the critical power action to hibernate so that you have the files back as soon as you power up [on AC] afterwards.

Thanks Denis. That sounds perfect, I will look in to that !

Do test your critical battery level to make sure it is useful. As batteries age you can find that you need to increase the level because the way Windows treats it is quite dumb.
You can also consider not using battery power unless it is necessary. Every time you use your battery you are using up part of its life.

I know it is unlikely I run out of power when connecting to the mains. I am not very smart, but also not very dumb. LOL :)
Using a laptop as a laptop is what I like most. It is used a LOT and the whole thing wears out fast. Normally need a new one every two years (keyboard / damaged screen / ssd too small) but not because of battery issues.

- Convert the whole lot to MS Office Access or another database. As I think you do not have MS Office Access in your 365 subscription, you could ask the other contributors for recommendations [I only know Access].

I realize that. But to confirm data integrity in a visual way (always see everything) a spreadsheet is way more effective. Also converting testing evaluating all this information from Excel to Access would be many months of work. Thta would be a waste of time because the whiole think works prety good at the moment.

- Restructure the spreadsheet so it is, as mentioned above, a collection of separate workbooks rather than a single mammoth one.

The workbooks would rely on eachother (so possibly they all need to be open). But they would be smaller. So when I run out of power I would still have the same issues, but since the file is smaller it is likely the damage is also smaller.
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
When I have something in Microsoft 365 active, and shut down the computer, it's still there when I reboot.

Hi Wyona. Remember I do not shutdown. I close the lid (probably using wrong power settings) or run out of power and Win11 goes poooooof
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
That's far too big of a file to be using in safely excel, honestly, you should look about transferring it all into some sort of database.

Ho Z3. Visual checks of data integrety by the user is not possible in a database. That is why I prefer it this way. IThe main excel sheet show all data all the time.

Data integrety seems well under control this way. Also implementing all this in to a database will be many months of work and after that a less effective UI will be the result.

Also excel make it much easier for me to include new stuff, checks, balances, calculations, lookups, etcetera. Going for a database would make the whole thing less effective for me, less fun to use, and more difficult to add additional features.

Only real big problem caused by being so huge is that recalculating and saving takes a lot of time. I guestimate each takes about one minute.
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge

jimbo45

Well-known member
Power User
VIP
Local time
11:28 AM
Posts
1,647
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Ho Z3. Visual checks of data integrety by the user is not possible in a database. That is why I prefer it this way. IThe main excel sheet show all data all the time.

Data integrety seems well under control this way. Also implementing all this in to a database will be many months of work and after that a less effective UI will be the result.

Also excel make it much easier for me to include new stuff, checks, balances, calculations, lookups, etcetera. Going for a database would make the whole thing less effective for me, less fun to use, and more difficult to add additional features.

Only real big problem caused by being so huge is that recalculating and saving takes a lot of time. I guestimate each takes about one minute.
Hi folks

Databases have far better data integrity and security these days -- also easy to limit access of parts of data to specific users etc etc. Using a GUI makes data browsing and editing in a DB easy as well -- Myphpadmin displays in any sensible browser -- just http://localhost/phpmyadmin and login - install WAMP on windows --easy enough !!

then login :

Screenshot_20220407_100941.png

select database

Screenshot_20220407_101239.png

and you "are in business".


I've been messing around with MariaDB (Thanks @z3r010) and it's brilliant - create your data into this type of DB - and then you can selectively edit tables etc with EXCEL if you want


For practice you can download a test sql database at : (All references to mysql are identical for mariadb - syntax / query language etc identical)


been playing around with this myself -- quite addictive -- all working on Windows as well as a test NAS server

Screenshot_20220407_095954.png

Screenshot_20220407_100037.png
cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

Try3

Well-known member
Power User
VIP
Local time
12:28 PM
Posts
573
Location
The proper part of London
OS
Windows 11 Home x64 Version 21H2 Build 22000.739
Is this a financial 'database' in Excel? I do the same - 44 cols x 3000 rows.

But I arranged mine so that I could chop off [archive] records more than a year old and the in-use file therefore never gets above a few MB.

You might be able to instigate similar cleaning up.

But the main topic remains setting up your Critical battery level to Hibernate at a battery level that gives you the emergency one minute that you need for the file to be fully saved.

Denis
 

My Computer

System One

  • OS
    Windows 11 Home x64 Version 21H2 Build 22000.739

GeneralLee01

Member
Thread Starter
Local time
1:28 PM
Posts
73
OS
Windows 11 Home 64-bit
Hi folks

Databases have far better data integrity and security these days -- . . . . . . <snip> . . . . . . Myphpadmin displays in any sensible browser . . . . . <snip>

Hi Jimbo. Thanks for all the info and pointing me in that direction. I all well aware of php and myphpadmin. But this is completely not suitable for my spreadsheet. Would be very inefficient and besides that it will be months work invested to convert. Also data integrety will be lower because of more problematic visual control when I actually perform an action I should not have done..
 

My Computer

System One

  • OS
    Windows 11 Home 64-bit
    Computer type
    Laptop
    Manufacturer/Model
    HP Pavilion x360 Convertible 14-DW1XXX
    CPU
    11th Gen Intel Core i7-1165G7 @ 2.80GHz
    Motherboard
    HP 87F4 (U3E1)
    Memory
    16024 MBytes
    Graphics Card(s)
    Iris Xe Graphics Revision 2
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1280x720 pixels
    Hard Drives
    NVMe KBG40ZNV1T02 KIOXIA (SSD) 953 GB
    Browser
    Microsoft Edge
Top Bottom