Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Values (don't want to be prompted)
When I save a sheet from my workbook into a file that I email I onl
copy one of the worksheets which tries to reference data from different worksheet(in the main template), this is just an aestheti question, but how can I make it so that it doesn't ask if the use wants to try and update the references -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Values (don't want to be prompted)
With your workbook open to the worksheet you wish to copy....
Open a blank workbook via FileNewWorkbook. Switch to the original and CRTL + A to select cells and Copy. Switch to blank workbook and Paste SpecialValues. Delete any blank worksheets from new workbook and FileSave As. Send this file to your user. Gord Dibben Excel MVP On Tue, 6 Jul 2004 15:05:11 -0500, RPIJG wrote: When I save a sheet from my workbook into a file that I email I only copy one of the worksheets which tries to reference data from a different worksheet(in the main template), this is just an aesthetic question, but how can I make it so that it doesn't ask if the user wants to try and update the references? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Values (don't want to be prompted)
can I do this with code? Would turning off the appevents work?
The file is generated by code and is all automated so doing it that wa might be difficult? I don't know. But would turning off appevents i files that say don't have the referenced worksheet work -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Values not Updating | Excel Discussion (Misc queries) | |||
Excel not updating values? | Excel Discussion (Misc queries) | |||
Updating Cell Values | Excel Discussion (Misc queries) | |||
Values not updating | Excel Worksheet Functions | |||
Updating the X and Y Values | Excel Programming |