Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2013, 10:52 AM
mikec mikec is offline xl table formula change on add row Windows XP xl table formula change on add row Office 2010 32bit
Advanced Beginner
xl table formula change on add row
 
Join Date: Nov 2012
Posts: 30
mikec is on a distinguished road
Default

Can't say I blame you for that. Instead I have set out to present the problem in a very simple fashion, which I should have done in the first place. The attached macroless worksheet demonstrates the problem I have encountered. It only occurs when adding the first line to an "empty" table but of course the corrupt formula persists for subsequent line additions. It only occurs with the A1:A2 format.
Attached Files
File Type: xlsx Problem.xlsx (13.1 KB, 12 views)
Reply With Quote
Reply

Tags
tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
xl table formula change on add row Need VBA Function in Word table formula nschroeder Word VBA 6 05-13-2013 03:58 PM
Referencing a value over 255 characters within a table PLUS strange formula behaviour TishyMouse Excel 2 01-08-2013 09:39 AM
Formula help in word table mygsdsni Word Tables 3 01-04-2012 02:36 PM
xl table formula change on add row Formula and Table Help! steveman1234 Word Tables 2 03-28-2010 06:20 PM
Help with Word table formula fritman99 Word Tables 1 09-02-2009 05:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 AM.


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