Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

updated values

ResolvedVersion 365

Updated Values

Hi there,
Every time I add information to a cell a pop up comes to tell me that I have updated values and looks as though it wants me to save the document. It's really interfering with my ability to edit the spreadsheet.

Many thanks,

GZ

RE: Updated Values

Hi George,

Thank you for the forum question.

It sounds like you have a VBA code in the file.

If you copy the file and delete all sensitive data in the file, you can send it to:

info@stl-training.co.uk

Then will have a look at it and if it is coded, I can remove the code.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Sun 6 Dec 2020: Automatically marked as resolved.

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.