Workbook not updating

RobbieC

Active Member
Joined
Dec 14, 2016
Messages
376
Office Version
  1. 2010
Platform
  1. Windows
Hi there, I have a massive workbook which is mainly inputted via user forms. I'm running excel 2010 and everything runs fine on my computer and 3 other machines I've built with similar spec.
However, I've just installed the workbook onto 2 new laptops (with same spec) and I appear to have a problem. Everything works fine for a while and then the workbook just stops updating cells.
I've been racking my brain to diagnose the problem but it keeps persisting.
Could this be down to the Office install? Or Windows update?
If anyone can point me in the right direction, I'd be very grateful.
Thanks
Rob
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
I have a massive workbook
how big is massive ? how many megabytes ?
does the workbook contain lots of formulas ?
how many rows in biggest sheet ?

the workbook just stops updating cells
what is not happening ?
- formulas not updating ?
- macros failing to complete ?


Before investigating anything else I would eliminate possibility of a peculiar memory issue
- test on much smaller workbook with same functionality
- save pared-down version of the workbook (ie remove most of the historic data)
- test on both "problem" laptops
 
Upvote 0

Forum statistics

Threads
1,224,743
Messages
6,180,686
Members
452,994
Latest member
Janick

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top