• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Update Values

Hi,

I have a formula in a ss linked to another file

=COUNT('G:\Asset Services Risk Team\Cash Nostros\[Asset Services Outstanding Cash Items.xls]Outstanding Items Report-1'!$H:$H)

As my Macro goes through, a screen comes up saying "Update Values" and tries to direct me to the file and press ok.

How can i surpress this error message?

I have put code to always update links on workbook open, but it is still looking for me to update those values

I have atatched a screenshot of where it makes me update values

Thanks
Seamus
Doc1.doc
0
Seamus2626
Asked:
Seamus2626
  • 2
1 Solution
 
Randy DownsOWNERCommented:
Try this - http://www.techrepublic.com/blog/msoffice/turn-off-error-checking-when-entering-numbers-into-excel-text-fields/428

Click the Excel Options button.
Click Formulas in the left column.
Under Error Checking, clear the Numbers Formatted As Text Or Proceeded By An Apostrophe check box.
0
 
Rory ArchibaldCommented:
Have you tried:
Application.Displayalerts = False
' your code
Application.Displayalerts = True

Open in new window

0
 
Rory ArchibaldCommented:
PS Is that the right screenshot?
0
 
Seamus2626Author Commented:
Thanks Rory!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now