Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2019, 09:25 AM
gambo gambo is offline Trying to link a cell from one worksheet to another Windows 10 Trying to link a cell from one worksheet to another Office 2016
Novice
Trying to link a cell from one worksheet to another
 
Join Date: Jan 2019
Posts: 1
gambo is on a distinguished road
Default Trying to link a cell from one worksheet to another

I click on cell in worksheet and type =up in the formula bar, then I highlight the cell in the worksheet I want to link from , hit enter, and the formula ='2018'!I69 appears in the cell instead of the number. Why is the formula appearing in the cell and not the number
Reply With Quote
  #2  
Old 01-18-2019, 10:26 AM
ArviLaanemets ArviLaanemets is offline Trying to link a cell from one worksheet to another Windows 8 Trying to link a cell from one worksheet to another Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

The cell is formatted as text!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to link a cell from one worksheet to another how do i use a named cell for each worksheet cwkotch Excel 3 11-03-2015 09:04 AM
link worksheet on shared file hifrank Word 0 06-24-2015 07:29 AM
Trying to link a cell from one worksheet to another Worksheet defined cell sums flextera Excel 3 06-17-2014 11:12 AM
Trying to link a cell from one worksheet to another getting the worksheet name in a cell derohanes Excel 9 02-14-2013 01:29 PM
click a cell to go to a worksheet victor Excel 0 10-27-2006 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft