Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / September 2004

Tip: Looking for answers? Try searching our database.

sorting and formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tim - 21 Sep 2004 23:43 GMT
I am trying to sort a table and the formulas for a
division equation are not following like on works.  The
equation may have been =(j20/k20)*100, that gets me a
percentage.  When i sort it may be moved to j2 & k2 but
the formula wont reflect that.  Please advise
Genine - 23 Sep 2004 12:47 GMT
Formulas in Word tables are absolute references, not relative. Unlike
formulae in Excel or Works spreadsheet they don't update if you add/delete
rows or move the formula. You will need to enter them again once you have
sorted your table.
Genine

> I am trying to sort a table and the formulas for a
> division equation are not following like on works.  The
> equation may have been =(j20/k20)*100, that gets me a
> percentage.  When i sort it may be moved to j2 & k2 but
> the formula wont reflect that.  Please advise
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.