146 reputation
7
bio website
location Tokyo, Japan
age
visits member for 1 year, 8 months
seen Jul 27 at 9:59

Jul
20
awarded  Popular Question
Apr
29
comment Excel 2013, can data be re-sorted automatically?
@Iowak, if you like please write up an answer and I will mark it as sought-after. Thanks again for your valuable help.
Apr
9
comment Excel 2013, can data be re-sorted automatically?
yes thanks, I fixed the issue now. Thanks
Apr
8
comment Excel 2013, can data be re-sorted automatically?
@lowak, the newly inserted is the last code block which runs in WorkSheet_Calculate(). The first code block that schedules workbook recalculation sits in "General" and the StartTimer() method is invoked upon the click of a button in one of the worksheets. I think I may have found the problem: The code that re-sorts the tables is referenced on ActiveSheet which is not correct when being on a different sheet and kicking off the "Workbook re-calculation macro"
Apr
8
awarded  Custodian
Apr
8
reviewed Approve suggested edit on Excel 2013, can data be re-sorted automatically?
Apr
8
revised Excel 2013, can data be re-sorted automatically?
added 829 characters in body
Apr
8
comment Excel 2013, can data be re-sorted automatically?
@lowak, thanks for your offer to get back on this, I find problems with my current macro within Worksheet_Calculate. My settings to Calculate are always set to manual, and I already run another macro that refreshes the whole workbook at specified intervals. My problem is that sometimes when I start the macro that refreshes at specified intervals I get a run time error that originates from the newly inserted macros that refresh the tables. I edited my question to show some code, do you mind taking a look? Thanks
Apr
7
awarded  Commentator
Apr
7
comment Excel 2013, can data be re-sorted automatically?
well just played with it and Worksheet_Change seems to be much better than sticking the macro into Worksheet_Calculate, for whatever reason. Runs pretty smoothly now and I guess I can just go with that for the time being. Thanks
Apr
7
comment Excel 2013, can data be re-sorted automatically?
So, I take it there is no function within Excel2013 that activates automated re-sorting of tables? I am surprised about that because conditional formatting adjusts automatically on any changes in source data. So, I find it hard to believe that no sorting functionality exists that re-sorts on changing data. I understand that I can simply record a macro and re-sort manually and plug the code into the WorkshSeet_Change() event method, but its extremely dirty, the slightest change in column renaming breaks the code to just name one issue.
Apr
7
awarded  Editor
Apr
7
revised Excel 2013, can data be re-sorted automatically?
edited title
Apr
7
asked Excel 2013, can data be re-sorted automatically?
Apr
7
comment Is there a dynamic sorting feature in Excel 2007/2010?
@dav, is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically (similar to conditional formatting) without having to click the re-sort button.
Dec
21
awarded  Supporter
Feb
21
awarded  Scholar
Feb
21
accepted Wakeup PC upon mouse click but not mouse move
Feb
21
comment Wakeup PC upon mouse click but not mouse move
Given the apparent impossibility of what I asked for I still mark your answer for the effort put in, thanks.
Feb
19
comment Wakeup PC upon mouse click but not mouse move
@Joe, agree its for a HTPC, the mouse is placed on the coffee table and I do not want the HTPC wake up from sleep each time the wireless mouse is moved by a bit.