LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
eel77
 
Posts: n/a
Default Formulas referencing other sheets

Normally when referencing cells on another worksheet, the formula bar will
display something like so,

=Sheet2!B15

Under what circumstance would the formula be displayed like the following?

=Sheet2!R[-226]C

And how do I change this back to the "normal" formula format?

Many thanks!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sheets back to formulas J. Freed Excel Discussion (Misc queries) 4 May 7th 05 12:17 AM
formulas referencing pivot table cells JW_WA Excel Worksheet Functions 1 February 8th 05 12:52 AM
Referencing Sheets in a Formula Christopher Anderson Excel Discussion (Misc queries) 1 January 31st 05 04:10 PM
formulas for employee time sheets RJ Excel Worksheet Functions 1 January 15th 05 12:36 AM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"