Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DavidA3878
 
Posts: n/a
Default Has anyone had formulas change automatically with no explanation?

I have a user who is using a simple workbook with formulas pulling data
between worksheets, but their formulas will change automatically with no
explanation. They tell me they are not adding or deleting any rows or
columns, just the data.
  #2   Report Post  
Alan
 
Posts: n/a
Default Has anyone had formulas change automatically with no explanation?

The only time I personally have experienced anything like that was in a
workbook which had a macro that deleted all rows beyond a certain point
using xlEndUp in the code.
Cutting and pasting could possibly be a factor, or maybe the file has been
corrupted in some way.
Is the user XL knowledgeable? It sounds more like a user error than anything
else to me.
Regards,
Alan.
"DavidA3878" wrote in message
...
I have a user who is using a simple workbook with formulas pulling data
between worksheets, but their formulas will change automatically with no
explanation. They tell me they are not adding or deleting any rows or
columns, just the data.



Reply
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
change default chart settings for new excel charts automatically Nedwardt Charts and Charting in Excel 0 October 20th 05 08:27 PM
How to prevent Excel 2003 from automatically change chart type Oscar II Charts and Charting in Excel 2 October 1st 05 02:57 PM
Formulas not recalculating when values change on another sheet Bill Excel Worksheet Functions 0 September 15th 05 10:29 PM
Automatically change text to uppercase Santie Excel Worksheet Functions 1 February 22nd 05 05:20 PM
How do I automatically change color of value if value is > 50 in . Vichingo Excel Discussion (Misc queries) 2 February 21st 05 11:42 AM


All times are GMT +1. The time now is 09:25 PM.

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"