changing formula

Excel formula

Guest

Posts: n/a

13th Apr 2010

I have the formula bellow, which is getting a number from a worksheet within
the permanent file to be added to the monthly worksheet.

=$H$270+'\\nnn.edu\filespace\shared\Shared\_NewShare\SCHEDULES\[Spring10Perm.xlsx]BSched'!$H282

When changes are made to the permanent file, these changes are not always
carried into the monthly worksheet. Has anyone encounter this problem.
Another recurring problem is deleted information is not permanently deleted.
It sometimes reappears.

we use office 2007 and this is a shared file

thanks for any feedback

« Can I use Sumproduct with the LEFT Function? | Help Creating Excel Formula »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing the range for averages with out changing the formula.	JessLRC	Microsoft Excel Worksheet Functions	0	20th Apr 2010 03:10 PM
how to edit formula without changing formula of each cell	=?Utf-8?B?c2FkYXQ=?=	Microsoft Excel Worksheet Functions	2	24th Apr 2007 02:02 PM
Changing formula to a value	newbie101	Microsoft Excel Worksheet Functions	1	16th Aug 2006 02:19 PM
Need Help changing FORMULA	zipper21	Microsoft Excel Misc	2	2nd Apr 2006 09:44 AM
Copy Formula Down Without Changing Entire Formula	=?Utf-8?B?cm95Lm9raW5hd2E=?=	Microsoft Excel Misc	3	16th Mar 2006 01:54 AM